JCL
1. Ways in which the you can paas on data from.jcl to cobol.: Dsn file, sysin, parm
2.How do u accept the data which is paased from Parm parameter.: Using linkage section.
3. How will u make any step run incase the job fails on previous condition- cond= only
4. Explain Disp position?
5. How will you write the logic when u have two file in input , you want to copy matching data from both file based on common key account number. We need to write the logic for copying matching data into One file and unmatching data in another file.
Ans:

Db2
1. Explain 811 - cursor not defined for selecting more then one row from table
2. Life cycle of cursor.- declare, open, fetch, close
3. How to write the query for updating the fields in table using cursor: Ans: this can be done using "with current of " in cursor .
4. Say we have one table with accnt number, accnt type . Accnt number is unique key. We need to fetch distinct accnt type with count.
Ans: select accnt type, count(*) from table group by 1;
5. Explain join and types of join?
6. Write query to fetch data from two table using join? By using sortjoin keys and also we can write two diff files using outfile. Files=1 with some.include condition and some.without for outfil files=2

Question

JCL
1. Ways in which the you can paas on data from.jcl to cobol.: Dsn file, sysin, parm
2.How do u accept the data which is paased from Parm parameter.: Using linkage section.
3. How will u make any step run incase the job fails on previous condition- cond= only
4. Explain Disp position?
5. How will you write the logic when u have two file in input , you want to copy matching data from both file based on common key account number. We need to write the logic for copying matching data into One file and unmatching data in another file. 
Ans: 

Db2
1. Explain 811 - cursor not defined for selecting more then one row from table 
2. Life cycle of cursor.- declare, open, fetch, close
3. How to write the query for updating the fields in table using cursor:  Ans:  this can be done using   "with current of "  in cursor .
4. Say we have one table with accnt number, accnt type . Accnt number is unique key. We need to fetch distinct accnt type with count.
Ans: select accnt type, count(*) from table group by 1;
5. Explain join and types of join?
6. Write query to fetch data from two table using join? By using sortjoin keys and also we can write two diff files using outfile. Files=1 with some.include condition and some.without for outfil files=2

Accepted Answer

Interview questions for Senior Consultant position on JCL and DB2

JCL: passing data using DSN file, SYSIN, and PARM parameters
JCL: accepting data passed from PARM parameter using linkage section
JCL: making a step run in case of job failure using COND=ONLY
JCL: explaining DISP position
JCL: writing logic to copy matching data from two input files based on a common key
DB2: explaining cursor not defined for selecting more than one row from table
DB2: life cycle of cursor - declare, open, fetch, close
DB2: writing a query to update fields in a table using cursor
DB2: fetching distinct account types with count from a table
DB2: explaining join and types of join
DB2: writing a query to fetch data from two tables using join and outfile

Top Capgemini Senior Consultant interview questions & answers

Popular interview questions of Senior Consultant

Top HR questions asked in Capgemini Senior Consultant