Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to retrieve file dictionary details of ADABAS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries
View previous topic :: :: View next topic  
Author Message
cooolguyin
Warnings : 1

New User


Joined: 12 May 2005
Posts: 10
Location: NY

PostPosted: Thu Jun 30, 2011 9:03 pm    Post subject: How to retrieve file dictionary details of ADABAS
Reply with quote

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
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jun 30, 2011 10:09 pm    Post subject:
Reply with quote

Hello,

You need to ask the dba. Everything you want is probably already available. . .
Back to top
View user's profile Send private message
cooolguyin
Warnings : 1

New User


Joined: 12 May 2005
Posts: 10
Location: NY

PostPosted: Fri Jul 01, 2011 12:02 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Fri Jul 01, 2011 12:10 am    Post subject: Reply to: How to retrieve file dictionary details of ADABAS
Reply with quote

You do not FTP to excel, at most You can FTP to a PC...
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jul 01, 2011 1:22 am    Post subject:
Reply with quote

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. . .

Quote:
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
All of this should be at the fingertips of the dba. . .
Back to top
View user's profile Send private message
cooolguyin
Warnings : 1

New User


Joined: 12 May 2005
Posts: 10
Location: NY

PostPosted: Fri Jul 01, 2011 7:17 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Jul 01, 2011 8:20 pm    Post subject: Reply to: How to retrieve file dictionary details of ADABAS
Reply with quote

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

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
Back to top
View user's profile Send private message
Ats

New User


Joined: 21 Jul 2010
Posts: 6
Location: Roaming

PostPosted: Mon Jul 04, 2011 12:45 pm    Post subject:
Reply with quote

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)
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 4 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us