Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Questions in VSAM, JCL, IEFBR14

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

New User


Joined: 24 Mar 2005
Posts: 2
Location: bangalore

PostPosted: Fri Apr 01, 2005 6:39 pm    Post subject: Questions in VSAM, JCL, IEFBR14
Reply with quote

I faced these questions at Codelinks, some of the questions are quite situation oriented. The questions are:

1) there r 2 files viz. fileA and fileB. Both can be any type of dataset(like sequential, any VSAM file). There r some records in both the datasets. U have to find the these records that r matching and move those particular records into a third file which again can be any type of dataset. How will u achieve the same if there r millions of records in both fileA and fileB?
3) What do u mean by overriding and can it be used in the above questions?
4) There is a record with logical record length of say 300. But the client want to increase the actual record by 4 bytes more without changing the logical record length. Explain how to achieve this?
5) What is the difference between comp and comp-3? What r the different sizes used in both the above usages? How can u use one of the two to solve question 4)?
7) You r allocating dataset by using JCLs. U code (New,catlg,catlg) in it. But the dataset is already there but u have to allocate the dataset without deleting the above coded DISP parameter in the JCL? Ans : (but doubtful )Use IEBFR14 in the separate step to delete the existing dataset(use DISP=new,delete,delete)
8) U have CICS screen Which have the following details:
EMp no???????.
Name:???????..
DEsig:??????.
Salary:????????.
U have two types of employees in the organisation viz clerks whose user id starts with C and that of managers who have user id starting with M. Both the types of the employees can run the same transaction id to access this screen.but when the managers run access the screen they can see the salary but when the clerks access it the salary field (both labeled and the field for the display of salary viz. Salary:????..) will not be displayed. How do u do this?
9) what is EIBBMSCA? What is its significance?
10) what r different types maintenance projects?
11) what is the importance of attribute A out of F, L, A , I and O attributes of any field of a map?

Avinash
Back to top
View user's profile Send private message

sivatechdrive

Active User


Joined: 17 Oct 2004
Posts: 190
Location: hyderabad

PostPosted: Wed Apr 06, 2005 9:46 am    Post subject: Re: Questions in VSAM, JCL, IEFBR14
Reply with quote

Hi Friend

some answers....

1..u can compare the the files using COMPAREX TOOL...it's very easy OR
u can use the Search option(3.12 or 3.13)..but here u cannot write to 3rd file OR u can use the IEBCOMPR option
A sample
Code:

//JS00xx EXEC PGM=IEBCOMPR
//SYSPRINT DD SYSOUT=*
//SYSUT1 DD DSN=xxx,DISP=SHR
//SYSUT2 DD DSN=yyy,DISP=SHR
//SYSIN DD DUMMY
/*


A return code of zero, Good stuff

rc of 12, records did not match

Caution is SDSF your records are displayed in hex.

3.the overridding means we have a proc which use one kind of input dataset set, if our JCl need some other input dataset we override it
//procedure-stepname.ddname DD DSN =

in the above senerio,we can write all the logic in one proc..we can gives different input datasets by overridding

4.the answer in in the 5th question,u can use comp,or comp3 which ensures minimum storage space for example
01 mf pic 9(9) ------- since default usage is display it occupies 9 bytes
01 mf pic 9((9) comp --occupies only 4 bytes
so u can use the remaining storege

5.this is answered many times in our forum..plz check

7.we delete the dataset in step1 using delete(dataset)
we may get return code 4 or 0 ,if no dataset is present we get 4 &
we create the dataset in step2

8.use ASSIGN command in cics and get the userid..do the logic accordingly

11.this is attribute filed.we can set the MDT ,colours,darken & mnay othe options here



Thanks
Siva
Back to top
View user's profile Send private message
me4mf2005@yahoo.com

New User


Joined: 24 Mar 2005
Posts: 2
Location: bangalore

PostPosted: Wed Apr 06, 2005 10:52 am    Post subject: Re: Questions in VSAM, JCL, IEFBR14
Reply with quote

Thanks for the reply:
but regarding the first question:
1) there r 2 files viz. fileA and fileB. Both can be any type of dataset(like sequential, any VSAM file). There r some records in both the datasets. U have to find the these records that r matching and move those particular records into a third file which again can be any type of dataset. How will u achieve the same if there r millions of records in both fileA and fileB?


if we r ask do the same by writing a COBOL program how can we do so without using any TSO/ISPF option like SuperC or without any tool?

avinash
Back to top
View user's profile Send private message
MGIndaco

Active User


Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy

PostPosted: Wed Apr 13, 2005 8:28 pm    Post subject:
Reply with quote

Hi avinash!
1) Try with a binary search from one file to another. This will able you to scan also a part of record you desire and more. This solution i very fast also for big big files and allow you to move in a third file the result of search;
3) as sivatechdrive;
4) I think that your system installation hide 4 byte. Is it a VB or a Vsam with variable record length?
7) use IDCAMS with listacat entry and you'll receive a rc=4 if your file does not exist and 0 if exist then, in the same step of IDCAMS you can delete it.
8) as sivatechdrive
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 VSAM Space Allocation mrgnndhmk JCL & VSAM 7 Sat Apr 22, 2017 12:42 am
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts VSAM RLS=NRI while doing IDCAMS sheersh JCL & VSAM 1 Tue Mar 07, 2017 1:55 pm
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us