Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to see the attributes of already existing VSAM File

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
RamsIBM

New User


Joined: 08 Jan 2007
Posts: 53
Location: Chennai

PostPosted: Thu Mar 06, 2008 11:55 am    Post subject: How to see the attributes of already existing VSAM File
Reply with quote

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

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Mar 06, 2008 12:40 pm    Post subject: Re: How to see the attributes of already existing VSAM File
Reply with quote

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

New User


Joined: 08 Jan 2007
Posts: 53
Location: Chennai

PostPosted: Thu Mar 06, 2008 1:08 pm    Post subject:
Reply with quote

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

Active User


Joined: 31 Aug 2006
Posts: 215
Location: India

PostPosted: Thu Mar 06, 2008 3:25 pm    Post subject: Re: How to see the attributes of already existing VSAM File
Reply with quote

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

Global Moderator


Joined: 14 Mar 2007
Posts: 10308
Location: italy

PostPosted: Thu Mar 06, 2008 5:33 pm    Post subject: Reply to: How to see the attributes of already existing VSAM
Reply with quote

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

New User


Joined: 07 Jul 2005
Posts: 41
Location: chennai

PostPosted: Thu Mar 06, 2008 8:35 pm    Post subject: Reply to: How to see the attributes of already existing VSAM
Reply with quote

for qn 6..Load b file to VSAM emplid as key and process the other file
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Mar 07, 2008 12:14 am    Post subject:
Reply with quote

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

New User


Joined: 08 Jan 2007
Posts: 53
Location: Chennai

PostPosted: Tue Mar 11, 2008 6:21 pm    Post subject:
Reply with quote

Guys
Thank you for your replys

Still am not clear on 4th question
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Mar 11, 2008 10:21 pm    Post subject:
Reply with quote

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

New User


Joined: 08 Jan 2007
Posts: 53
Location: Chennai

PostPosted: Thu Mar 13, 2008 1:19 pm    Post subject:
Reply with quote

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

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Mar 13, 2008 2:33 pm    Post subject:
Reply with quote

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.. icon_smile.gif

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

New User


Joined: 08 Jan 2007
Posts: 53
Location: Chennai

PostPosted: Thu Mar 13, 2008 2:55 pm    Post subject:
Reply with quote

Now I am clear....

Thanks Anuj....
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Mar 14, 2008 12:23 am    Post subject:
Reply with quote

RamsIBM wrote:
Now I am clear....
heh heh..Not You, Your doubts .. icon_smile.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Sun Mar 16, 2008 2:10 pm    Post subject:
Reply with quote

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.. icon_smile.gif
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Compare yesterday's date to the one o... migusd SYNCSORT 8 Fri Sep 22, 2017 11:35 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm
No new posts editting the file by inserting zeros ... pramodrsingh DFSORT/ICETOOL 9 Mon Aug 21, 2017 5:58 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us