Relative Record Number in DB2?

[Trevor_B_]

Has anybody had success retreiving relative record number of a DB2 (8.1) DB? I've used SELECT RRN(column), SELECT rrn, column and a mulititude of other options. Tried CF 6.1,7.02 and 8, none of which have worked. Using latest JDBC drivers (I think)

Any insight would be appreciated.

Thanks!

[Guest]

Have you tried using the correlative you assigned to the file name?

select rrn(a) from sysibm.sysdummy1 a

[Trevor_B_]

What is a?

[Guest · Accepted solution]

a is the correlative I associated with the file name so I don't have to type the whole file name every time I reference it.

You could also try:

select rrn(sysdummy1) from sysibm.sysdummy1

[Trevor_B_]

Thanks for the help. Don't know why I've never tried to use table name. Works likes a champ.