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 find records in IDMS without OLQT or DMLO or QOL etc.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
View previous topic :: :: View next topic  
Author Message
Supriyo

New User


Joined: 22 Feb 2008
Posts: 2
Location: kolkata

PostPosted: Mon Feb 25, 2008 11:51 am    Post subject: how to find records in IDMS without OLQT or DMLO or QOL etc.
Reply with quote

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

dick scherrer

Site Director


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

PostPosted: Mon Feb 25, 2008 8:31 pm    Post subject:
Reply with quote

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

New User


Joined: 22 Feb 2008
Posts: 2
Location: kolkata

PostPosted: Tue Feb 26, 2008 11:43 am    Post subject: Reply to: how to find records in IDMS without OLQT or DMLO o
Reply with quote

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. icon_question.gif ...supriyo
Back to top
View user's profile Send private message
nirmal.poikaikumaran

New User


Joined: 29 Nov 2005
Posts: 66
Location: Bangalore

PostPosted: Tue Feb 26, 2008 7:39 pm    Post subject:
Reply with quote

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

Site Director


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

PostPosted: Tue Feb 26, 2008 8:32 pm    Post subject:
Reply with quote

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

New User


Joined: 28 Mar 2008
Posts: 1
Location: INDIA

PostPosted: Fri Mar 28, 2008 7:22 pm    Post subject: Reply to: how to find records in IDMS without OLQT or DMLO o
Reply with quote

buddy..

try to check in the compile listing of any of the batches..hopefully ur problem will be solved.
Back to top
View user's profile Send private message
Ace

New User


Joined: 03 May 2007
Posts: 14
Location: Delhi

PostPosted: Mon May 26, 2008 10:37 am    Post subject: Reply to: how to find records in IDMS without OLQT or DMLO o
Reply with quote

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

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am


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