Hi,
I am posting some questions asked in the Interview.I have given some hints for my questions.
1)How will you split one Input file into two output files?
2)what is the maximum value that a subscript can use?
3)How will You change the column name in a table.explain the steps.
i think with alter command we can add a column.I think with alter command we can't change the column name.i want to know how can we change the column name in a table.
4)what are the do's and dont's of DB2?
5)What is performance monitoring in DB2?
6)How will you pass parameters from JCL to a cobol program other than parm statement & sysin dd*?
7)1 2 3
4 5 6-----------Table Array
7 8 9
Using a Cobol Logic can you display it in the Program. How will you display it in the procedure division.
My answer is i think we have to use a three dimensional table.
Table a( )
Table b( )
Table c( )
8)Lrecl=80,Blksize=800
Lrecl=80,Blksize=8000
How many bytes are read in I/O in each of the cases.
9)I have a 80 byte string in cobol.it is having A Character.I want to replace A by Z.How will i do that.
My thinking is can we use inspect statement.
10)In a db2 program a column name is given wrong.whether i will get error during compilation time or run time.
I think it is during compilation time.is my thinking correct
11)Can you send me the link for various compiler options
Joined: 25 Jan 2004 Posts: 180 Location: Toronto, Canada
Badari wrote:
Hi,
I am posting some questions asked in the Interview.I have given some hints for my questions.
1)How will you split one Input file into two output files?
2)what is the maximum value that a subscript can use?
3)How will You change the column name in a table.explain the steps.
i think with alter command we can add a column.I think with alter command we can't change the column name.i want to know how can we change the column name in a table.
4)what are the do's and dont's of DB2?
5)What is performance monitoring in DB2?
6)How will you pass parameters from JCL to a cobol program other than parm statement & sysin dd*?
7)1 2 3
4 5 6-----------Table Array
7 8 9
Using a Cobol Logic can you display it in the Program. How will you display it in the procedure division.
My answer is i think we have to use a three dimensional table.
Table a( )
Table b( )
Table c( )
8)Lrecl=80,Blksize=800
Lrecl=80,Blksize=8000
How many bytes are read in I/O in each of the cases.
9)I have a 80 byte string in cobol.it is having A Character.I want to replace A by Z.How will i do that.
My thinking is can we use inspect statement.
10)In a db2 program a column name is given wrong.whether i will get error during compilation time or run time.
I think it is during compilation time.is my thinking correct
11)Can you send me the link for various compiler options
Thanks & Regards
Badari
Badari,
Set of similar questions are already asked by others...
1)How will you split one Input file into two output files?
Using SORT you can do this
3)How will You change the column name in a table.explain the steps.
i think with alter command we can add a column.I think with alter command we can't change the column name.i want to know how can we change the column name in a table.
This is answered in Db2 forum please check
7)1 2 3
4 5 6-----------Table Array
7 8 9
Using a Cobol Logic can you display it in the Program. How will you display it in the procedure division.
Yes what ever you are saying is one of the possible solution.
9)I have a 80 byte string in cobol.it is having A Character.I want to replace A by Z.How will i do that.
My thinking is can we use inspect statement.
yes thats true
10)In a db2 program a column name is given wrong.whether i will get error during compilation time or run time.
I think it is during compilation time.is my thinking correct
