Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Record Number

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Record Number

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

  • #2
    Record Number

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

    Comment


    • #3
      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?

      Comment


      • #4
        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...

        Comment

        Working...
        X