MVSFORUMS.com

jagfit · Beginner Joined: 27 Sep 2003 Posts: 5 Topics: 2

Hi ,

I need to delete 'N' number of records from a table. Other than using the cursor and deleting , is there any other way out ? For example, like Oracle's ROWNUM , is anything similar avaiable in DB2 ? Or is there any other method available(functions etc) ? Please note that I need to delete the records through program only. So I cannot use unload or any option like that.

Thanks,
_________________
Regards,
Jagfit

kolusu · Posted: Fri Nov 14, 2003 6:42 am Post subject:

Jagfit,

why do you need a cursor to delete? A simple delete statement with proper where clause will do. Db2 version & supports Rownum. rownum must be a column in your table.

Hope this helps...

cheers

kolusu

jagfit · Beginner Joined: 27 Sep 2003 Posts: 5 Topics: 2

Kolusu,

Thanks for the pointer..Did you mean DB2 Version 7 ? Also , can you point me to a manual which describes ROWNUM ? I searched,but could not locate it..

Thanks,
_________________
Regards,
Jagfit

kolusu · Posted: Fri Nov 14, 2003 8:51 am Post subject:

Jagfit,

Yes I meant DB2 V7.In DB2 it is actually called ROWID.search in the following link for Rowid

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/CCONTENTS?DT=20010710165542

Also check this link for ROWID function.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/3.2.70?SHELF=&DT=20010718164132&CASE=

Hope this helps...

cheers

kolusu

jagfit · Beginner Joined: 27 Sep 2003 Posts: 5 Topics: 2

Thanks Kolusu. I will go through these.
_________________
Regards,
Jagfit