IBM MAINFRAME HELP FORUMS for COBOL, JCL, CICS, DB2, IMS etc...

Supriyo · Joined: 22 Feb 2008 Posts: 2 Location: kolkata

Suppose i have a database and i know the schema/subschema name and i need to find out what are the records present and also their record structure? But
1.)i don't have the OLQT or DMLO or QOL(ie. any query online tool like DBOL etc as the client doesnt provide that.)
2.) I also cannot write any cobol programs to fetch the records.

Is there any commands or utility in IDD/OOAK by which this can be done..
I am new in IDMS so it will be helpful if u can suggest any sites or manuals etc.

dick scherrer · Joined: 23 Nov 2006 Posts: 7998 Location: 221 B Baker St

Hello Supriyo and welcome to the forums,

Quote: I am new in IDMS so it will be helpful if u can suggest any sites or manuals etc. If your organization is licensed to use IDMS, all of the documentation may be downloaded for free from the CA Support site.

The material is covered by copyright and may neither be posted nor linked to from our forums.

Supriyo · Joined: 22 Feb 2008 Posts: 2 Location: kolkata

Actually my company donot have CA products (so cannot get free materials from CA site )but we want to access our client database and we donot have any permission to use "OLQ or IDD or DMLO etc"(because they are not available with client).
So my question is --> how can i get to see what are the records present in IDMS and view them?
Since i had worked in AS400 (where they have commands like: wrkmbrpdm,dsplib etc) are there any such commands or ways in IDMS ?
IDMS must contain any "something" on its own by which i can access their records i suppose. :?: ...supriyo

nirmal.poikaikumaran · Joined: 29 Nov 2005 Posts: 50 Location: Bangalore

I believe you can easily submit a batch job to sweep the contents of the IDD to fetch a report.

Sample JCL IS

//IDMSRPTS EXEC PGM=IDMSRPTS,REGION=2000K
//STEPLIB DD DSN=XXXX.SDMS.LOAD,DISP=SHR
//SYSJRNL DD DUMMY
//SYSOUT DD SYSOUT=*
//*YSLST DD SYSOUT=*,DCB=BLKSIZE=3059
//SYSLST DD DSN=XXX.ABCD.IDD09,
//* DISP=SHR
// DISP=(NEW,CATLG,CATLG),
// UNIT=SYSDA,SPACE=(CYL,(10,10),RLSE),
// DCB=(RECFM=FB,LRECL=133,BLKSIZE=0)
//SYSIDMS DD *
DICTNAME=DICTAP
/*
//SYSIPT DD *
SCHEMA=SCHEMANAME VERSION=(HIGH)
SCHRPT SSCRPT
/*

This is how we used to get a report of the data, s othat without getting into database we can actually get to see the record structure.But only record structure and set ,area structure can be viewed in this manner

dick scherrer · Joined: 23 Nov 2006 Posts: 7998 Location: 221 B Baker St

Hello,

If your client will permit your group to access the idms environment, they (their dba(s)) need to tell you how you are to work in that environoment.

It may be as simple as requesting the database definitions from the database support people.

Maheshwar · Joined: 28 Mar 2008 Posts: 1 Location: INDIA

buddy..

try to check in the compile listing of any of the batches..hopefully ur problem will be solved.

Ace · Joined: 03 May 2007 Posts: 14 Location: Delhi

I too agree with Dick..You need to request your DBA's to send you the Bachman diagrams and other relevant information to work in IDMS