Record Number

[Guest.Visitor]

In SQL for DB2 I need access record by record number. How? In ORACLE I can use ROWID.

[Guest.Visitor]

Record Number

I think you can do the following: select * from file where rrn(file) = some integer

[weining.xu@aig.com]

Record Number

After a table has been load the data, delete the data, load the data again. RRN for the new data may not start from 1. How do reset RRN start from 1 again?

[bernhard.enderle@uta.de]

Record Number

you can execute the command "RGZPFM Table" from a command line - or you can write a little cl-program only with "RGZPFM Table" and call this CL-program...