How to see the attributes of already existing VSAM File

RamsIBM · New User Joined: 08 Jan 2007 Posts: 53 Location: Chennai

Hi Friends,

One of my friend attend the interview and we were discussing about the questions. For Some questions I couldnt give correct answer. Possible can you please quys go through reply answers for below questions.

1)Total five subprograms are there namely A,B,C,D,E.
Its calling in the order of A->B->C->D->E
(i.e) Acalls B and B in turn calls C so on....
If I do some changes in C or in any subprogams, do I need
recompile all subprograms or only Changed one.

2)How to see the attributes of already existing VSAM File
3)How to move a VSAM file from one region to another region
4)Created 6 generation of GDGs in a program, how to refer 4th and 5th generation??
Shall we give(for example) gdgname(4)/gdgname(5) like this? Simillaryly shall we give gdgname(-4) and gdname(-5) to refer old ones?
5)A program having ten SQL query, how will you give different isolation level for each query?
6)A and B are two sequential file . A contains 50 employees id, B contains Lakhs of employee records. Which is the best logic to find out the information of every record A in B.

Anuj Dhawan · Posted: Thu Mar 06, 2008 12:40 pm

RamsIBM · New User Joined: 08 Jan 2007 Posts: 53 Location: Chennai

Thanks you for your reply..

I couldn't answer for 2nd and 6th question answer

Where I have to use DITTO and perhaps??

Since I am in bench I don't have mainframe connection.

4)
As per my knowldge before end of the program we refer as gdgname(4)/gegname(5) or gdgname(-5) but after end of the program, We can refer as 0 current , +1/-1 we can't use 4 and 5. But am not sure...

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India

enrico-sorichetti · Posted: Thu Mar 06, 2008 5:33 pm

Usually interview questions, expect for an answer, solutions related to
plain/vanilla environments, which means no add on product/tools

FILEAID and DITTO, even if from different companies are products You must pay for

the simple, plain, always available solutions in a mvs-z/OS system are the good old
IDCAMS LISTCAT for batch jcl or LISTC for a tso command

balajiofcrrcoe · New User Joined: 07 Jul 2005 Posts: 41 Location: chennai

for qn 6..Load b file to VSAM emplid as key and process the other file

Anuj Dhawan · Posted: Fri Mar 07, 2008 12:14 am

RamsIBM · New User Joined: 08 Jan 2007 Posts: 53 Location: Chennai

Guys
Thank you for your replys

Still am not clear on 4th question

Anuj Dhawan · Posted: Tue Mar 11, 2008 10:21 pm

Hi,

Consider the below scenario:

RamsIBM · New User Joined: 08 Jan 2007 Posts: 53 Location: Chennai

Hi Thankyou for your time.

But in your explanation you gave as "After JOB1 ends I.M.GDG(+4) will be I.M.GDG.G0000V24. If later You want to refer back to GDG-> I.M.GDG(+3), it will be I.M.GDG(-1);"
I couldn't understand the difference between after... and later...

From your example, as per my understanding after Job1 ends , we can refer I.M.GDG.G0000V24 as I.M.GDG(0) not I.M.GDG(+4).

Please correct me if my understanding is wrong.

Anuj Dhawan · Posted: Thu Mar 13, 2008 2:33 pm

RamsIBM · New User Joined: 08 Jan 2007 Posts: 53 Location: Chennai

Now I am clear....

Thanks Anuj....

Anuj Dhawan · Posted: Fri Mar 14, 2008 12:23 am

Anuj Dhawan · Posted: Sun Mar 16, 2008 2:10 pm

Hi,

Please read this I.M.GDG.G0000V24 as I.M.GDG.G0024V00 etc. Chnaging version is not in use now.

P.S.: Sometimes Your fingers work faster than Yout mind..