how to identify a programe if its using a VASM file

sumannaidu · New User Joined: 21 May 2005 Posts: 13 Location: mumbai

Hi,

By seeing a program how can we say its using a VSAM file and which VSAM its using.?

rgds
suman

William Thompson · Posted: Wed Sep 19, 2007 5:29 pm Post subject:

Isn't the key the SELECT statement?

agkshirsagar · Posted: Wed Sep 19, 2007 5:29 pm Post subject:

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

diwa_thilak · Posted: Fri Sep 21, 2007 11:42 am Post subject:

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.

BalaMuraliL · New User Joined: 01 Aug 2007 Posts: 11 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.

sumannaidu · New User Joined: 21 May 2005 Posts: 13 Location: mumbai

i thank you all for the explanation.