View previous topic :: View next topic
|
Author |
Message |
sumannaidu
New User
Joined: 21 May 2005 Posts: 13 Location: Bangalore
|
|
|
|
Hi,
By seeing a program how can we say its using a VSAM file and which VSAM its using.?
rgds
suman |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
Isn't the key the SELECT statement? |
|
Back to top |
|
|
agkshirsagar
Active Member
Joined: 27 Feb 2007 Posts: 691 Location: Earth
|
|
|
|
In a program-
If it contains ORGANIZATION IS INDEXED then it is using KSDS.
If it contains ORGANIZATION IS RELATIVE then it is using RRDS.
If SELECT clause contains ASSIGN TO AS-xxxxxxxx then ESDS.
Now to find which VSAM-
search for program name in your PROCLIB and JCLLIB.
Read the procedure for the DDNAME you got from the program. ( Remember 'assign to xxxxxxxx' will be DDNAME used in JCL )
Please let us know if I missed something or interpreted your question wrongly |
|
Back to top |
|
|
diwa_thilak
Active User
Joined: 13 Jul 2006 Posts: 205 Location: At my desk
|
|
|
|
Suman,
The simple way will be as suggested by Abhijit. One more view is give a scan for the program and identify the job using the program.
If you open the job, you can easily identify the inputs to the program and their types. |
|
Back to top |
|
|
BalaMuraliL
New User
Joined: 01 Aug 2007 Posts: 10 Location: Pune
|
|
|
|
Hi Suman,
By seeing ORGANIZATION you can decide whether it is VSAM or Non-VSAM.
As agkshrisagar mentioned above, the one way is
In a program-
If it contains ORGANIZATION IS INDEXED then it is using KSDS.
If it contains ORGANIZATION IS RELATIVE then it is using RRDS.
If SELECT clause contains ASSIGN TO AS-xxxxxxxx then ESDS.
Second way is .. In SELECT card, if you find "RECORD KEY IS" phrase then it means it is KSDS VSAM file / "RELATIVE KEY IS" means then it is RRDS VSAM file.
Hope this information will hlep you.. let me know if you have any questions. Thanks. |
|
Back to top |
|
|
sumannaidu
New User
Joined: 21 May 2005 Posts: 13 Location: Bangalore
|
|
|
|
i thank you all for the explanation. |
|
Back to top |
|
|
|