View previous topic :: View next topic
|
Author |
Message |
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. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
RamsIBM wrote: |
1)Total five subprograms are there namely A,B,C,D,E. Its calling in the order of A->B->C->D->E |
If changes are in Linkage-section of C, and all the respective linkages are absolute, only B (& C ofsourse) needs to be recompiled. If changes are not in linkages then only the changed program.
Quote: |
2)How to see the attributes of already existing VSAM File |
DITTO, perhaps.
Quote: |
3)How to move a VSAM file from one region to another region |
NDM
Quote: |
4)Created 6 generation of GDGs in a program, how to refer 4th and 5th generation?? |
What do you think?
Quote: |
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. |
SORT them ona emp-ID, READ %)-record file RESEARCH ALL in other if COBOL.
IFTHEN/OVERLAY if SORT. |
|
Back to top |
|
|
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... |
|
Back to top |
|
|
sri_mf
Active User
Joined: 31 Aug 2006 Posts: 218 Location: India
|
|
|
|
Quote: |
2)How to see the attributes of already existing VSAM File
|
U can see it using file aid.Go to option 3 provide ur vsam file base and then enter.U will get the total info abt the Vsam file. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
RamsIBM wrote: |
I couldn't answer for 2nd and 6th question answer. Where I have to use DITTO and perhaps?? |
DITTO is IBM Data Interfile Transfer, Testing, and Operations Utility. As enrico said, it's a third party tool. Try TSO DITTO, if this is inetalled at Your site it'll be invoked.
'Perhaps' is an English word meant for 'may be, possibly'. So i wanted to say may be DITTO can be used
For 6the question :
SORT them on emp-ID, READ 50-record file and ESEARCH ALL in other file if in COBOL You want to implement it.
If You would like to do it using SORT IFTHEN/OVERLAY can be used. |
|
Back to top |
|
|
RamsIBM
New User
Joined: 08 Jan 2007 Posts: 53 Location: Chennai
|
|
|
|
Guys
Thank you for your replys
Still am not clear on 4th question |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi,
Consider the below scenario:
Code: |
//JOB1
.
.
//STEP0001 DD DSN=I.M.GDG(0)
.
.
//STEP0004 DD DSN=I.M.GDG(+1)
.
.
//STEP0007 DD DSN=I.M.GDG(+2)
.
.
//STEP0010 DD DSN=I.M.GDG(+3)
.
.
//STEP0013 DD DSN=I.M.GDG(+4)
.
.
//*JOB1ends
|
Now when the control 'enters' in JOB1 & "I.M.GDG " has its gdg I.M.GDG.G0000V20 in place before 'entrance' then I.M.GDG(0) will be equivalent to I.M.GDG.G0000V20, add 1 in 20 to get subsequent qualified name of GDGs.
After JOB1 ends I.M.GDG(+4) will be I.M.GDG.G0000V24. If later You want o refer back to GDG-> I.M.GDG(+3), it will be I.M.GDG(-1); provided no other JOB has created a next GDG.
Hope this helps. |
|
Back to top |
|
|
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. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Quote: |
as per my understanding after Job1 ends , we can refer I.M.GDG.G0000V24 as I.M.GDG(0) not I.M.GDG(+4). |
Yes, you are right..
RamsIBM wrote: |
I couldn't understand the difference between after... and later... |
By 'Later' I menat, if you are using GDG(+3) of JOB1 in another job which runs 'after' JOB1 then you could refer the gdg the way I showed. 'after' means JOB1 is over. |
|
Back to top |
|
|
RamsIBM
New User
Joined: 08 Jan 2007 Posts: 53 Location: Chennai
|
|
|
|
Now I am clear....
Thanks Anuj.... |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
RamsIBM wrote: |
Now I am clear.... |
heh heh..Not You, Your doubts .. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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.. |
|
Back to top |
|
|
|