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