MVSFORUMS.com

[badri5]

Hi,
Here are some of interview questions.

1)By seeing a DB2 table how will I find out which columns are having constraints
2)In one column of a Db2 table i want to have values like 1,2,3 without using in clause.how will i do that
3)By seeing the jcl how will you find out whether the step is having sort other than external sort.
4)Using redefines clause in cobol which one will give severe error when the redefined clause is more or less.
5)In a db2 table i want to add a column.where do we add in the beginning or in the end.
6)My cobol program is having sort.If we have files we define using assign clause in Program and JCL.For sort in program should i assign for it in the jcl
7)which one is more preferable.Declaring cursor in working storage section or in Procedure division.

Thanks

Badri

[kolusu]

badri5,

1. You only will have headache staring at a DB2 table. The answer is NO
2. If the column is defined as character , simply insert a row into the table
3. NO
4. None
5. Depends on the use of column to be added. Usually it is done at the end which involves less work.
6. NO
7. my personal preference is working storage but it doesn't matter where it is defined.

Kolusu

[Nic Clouston]

3. The JCL MAY have DD statements for SORT libraries and files - but not necessarily if the defaults are OK.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.