|
View previous topic :: View next topic
|
| Author |
Message |
Supriyo
New User
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. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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. |
|
| Back to top |
|
|
Supriyo
New User
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 |
|
| Back to top |
|
|
nirmal.poikaikumaran
New User
Joined: 29 Nov 2005
Posts: 66
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 |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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. |
|
| Back to top |
|
|
Maheshwar
New User
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. |
|
| Back to top |
|
|
Ace
New User
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 |
|
| Back to top |
|
|
|
|
