How do you SELECT the relative record number(s) of records from an SQL query?
I am querying a plain physical file, one with no DDS. It is used as a log within an application and has no key fields or logical files attached.
With SQL statements, I am able to select records "SUBSTRying" the whole single records. But I am interested in obtaining the corresponding relative record numbers of each selected row.
How do you do that?
Thanks in advance.