
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
select * from recordfile where record_number = 42;
record_number is a pseudo column that AcuXDBC maintains, it does not exist in the actual file

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
select * from recordfile where record_number = 42;
record_number is a pseudo column that AcuXDBC maintains, it does not exist in the actual file