Interview questions
Select messages from
# through # FAQ
[/[Print]\]

MVSFORUMS.com -> Interview Q & A

#1: Interview questions Author: badri5 PostPosted: Thu Feb 04, 2010 12:05 pm
    —
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

#2:  Author: kolusuLocation: San Jose PostPosted: Fri Feb 05, 2010 11:52 am
    —
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

#3:  Author: Nic CloustonLocation: At Home PostPosted: Fri Feb 05, 2010 1:36 pm
    —
3. The JCL MAY have DD statements for SORT libraries and files - but not necessarily if the defaults are OK.



MVSFORUMS.com -> Interview Q & A


output generated using printer-friendly topic mod. All times are GMT - 5 Hours

Page 1 of 1

Powered by phpBB © 2001, 2005 phpBB Group