Get all the File Names in a given database.

, , ,
1

Hi,

I tried to explore a lot, but I couldn’t find an answer to my requirement.
My requirement is to fetch all the file names present in a given database in Adabas.

Any help or guidance is appreciated.

2

Run the ADAREP utility to generate a report.

To manipulate the file names programmatically, parse the report.

3

If you want the Adabas File names (max. 16 characters) then use Ralph’s suggestion.
If you want the Natural DDM names (max. 32 characters) then you can call the Natural subprogram SYSEXT.USR1056N.

4

Thanks Ralph and Peter. My plan is to only fetch the File Names/Nbr in a given Database, so that I can use a Native SQL pgm to fetch all the records in all those files present in that database.