MVSFORUMS.com

edkir98 · Posted: Mon Sep 22, 2008 2:16 am Post subject: Insert Into... Select

Is it possible to use INSERT INTO statement with SELECT for only some rows..like.. I want to insert only the first 100 rows from the select statement..

for ex. a statement like this

danm · Intermediate Joined: 29 Jun 2004 Posts: 170 Topics: 73

Try:
INSERT INTO <table name>
SELECT field1,
field2,
field3
FROM table1
FETCH FIRST 100 ROWS ONLY

edkir98 · Posted: Tue Sep 23, 2008 1:16 am Post subject:

Fetch first 100 rows only is only during select..this will not work..
_________________
Thanks

Dibakar · Posted: Sun Sep 28, 2008 1:47 pm Post subject:

edkir98,

Isn't it supposed to be like declare cursor for first 100 records and then fetch and insert each individually?

Refrence - http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/sqlp/rbafycursorexamp.htm

Diba