Get all the File Names in a given database.

Anurag_Singh · July 3, 2018, 5:21pm

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.

Ralph_Zbrog · July 4, 2018, 1:00am

Run the ADAREP utility to generate a report.

To manipulate the file names programmatically, parse the report.

system · July 5, 2018, 1:50am

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.

Anurag_Singh · July 5, 2018, 7:18am

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.