How to use XDBC to read a relative file
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?
Re: How to use XDBC to read a relative file
select * from recordfile where record_number = 42;
record_number is a pseudo column that AcuXDBC maintains, it does not exist in the actual file