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?
Joined: 17 Oct 2004 Posts: 191 Location: hyderabad
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
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 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?
Joined: 10 Mar 2005 Posts: 432 Location: Milan, Italy
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