How to retrieve file dictionary details of ADABAS

cooolguyin · New User Joined: 12 May 2005 Posts: 10 Location: NY

Hi,

I need to get all field details including format,length, Abstract of multiple files . I know we have a option to view in Predict by each field. But I need to get the details probably in a dataset for more than 100 fields. Please let me know if there is a way .

Any guidance would be helpful.. Thanks very much

dick scherrer · Posted: Thu Jun 30, 2011 10:09 pm

Hello,

You need to ask the dba. Everything you want is probably already available. . .

cooolguyin · New User Joined: 12 May 2005 Posts: 10 Location: NY

Yes I did. DBA ran the job and provided the output. However the output format is not good to get it ftp into excel.

So my question here is in which file predict stores the field name,length etc; including Abstract of field, so that i can write a pgm to query the particular file and get the o/p with desired format

enrico-sorichetti · Posted: Fri Jul 01, 2011 12:10 am

You do not FTP to excel, at most You can FTP to a PC...

dick scherrer · Posted: Fri Jul 01, 2011 1:22 am

Hello,

Suggest you work with the dba to generate a proper delimited output suitable for downloading.

The delimited data will easily import into Excel or some other PC application. . .

cooolguyin · New User Joined: 12 May 2005 Posts: 10 Location: NY

Ok Finally I got the answer for my question. All these details that we see in predict are in SYSDIC-EL file. We can write our own program to get the details in desired format.

dick scherrer · Posted: Fri Jul 01, 2011 8:20 pm

Good to hear it is working for you - thank you for letting us know

Do keep in mind that providing this type of info is almost always considered part of the dba's work - we have the access and knowledge for the database systems we support (i just don't happen to support Adabas).

d

Ats · New User Joined: 21 Jul 2010 Posts: 6 Location: Roaming

cooolguyin,

You may also use L V file-name or L DDM ddm-name. This can also be invoked thruough a JCL (no, it cannot - running the right utility can, but jcl cannot) and write output into a dataset, later that dataset can be transfered to PC in a notepad. (ofcourse you need access to use L V or L DDM in batch)