How to use XDBC to read a relative file

[RobertRedekop]

Hi.  XDBC manual says you can make an XFD file for a relative cobol file.  And you can.  Once you have, how do you access a specific record?  When I google how to use SQL to select a specific record, I get information on LIMIT/OFFSET keywords (not in the manual) and ROW_NUMBER function for window processing (not in the manual.

So, can I use XDBC to access a specific record#, or do I have to change my record layout(s) to include a flag field which can be searched with the "WHERE" clause?

[shjerpe · Accepted solution]

  select * from recordfile where record_number = 42;

record_number is a pseudo column that AcuXDBC maintains, it does not exist in the actual file