View previous topic :: View next topic
|
Author |
Message |
Badari
New User
Joined: 28 Oct 2004 Posts: 3
|
|
|
|
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 |
|
Back to top |
|
|
jz1b0c
Active User
Joined: 25 Jan 2004 Posts: 160 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
yes you are right |
|
Back to top |
|
|
|