View previous topic :: View next topic
|
Author |
Message |
veda Currently Banned New User
Joined: 03 Mar 2005 Posts: 2
|
|
|
|
Let me give some of the interview ?s i faced..
Answer Please..
1. What is the maximum limit for length for a COBOL copybook?
2. What is internal storage for COMP and COMP-3 for a value "12547"?
3. What is maximum value (in bytes and value) that can be passed from jcl to COBOL thru parm
4. What is maximum value (in bytes and value) that can be passed from jcl to COBOL thru sysin?..
5. How many values can be acceptable in one ACCEPT in COBOL..
5.i. Scenario
In jcl
//sysin dd *
123,124..(what is limit)
5.ii. Scenario
In jcl
//sysin dd *
123
124
(what is limit)
6. What is use of Explain parameter in BIND CARD?
7. How many DBRM/Package/Plan will create for a DB2 Module?
8 Which one is efficient Package/Plan?
9. OPEN cursor - What it will do other than locating the record?
10. Declaration of length of EIBCALEN? |
|
Back to top |
|
|
skkp2006
New User
Joined: 14 Jul 2006 Posts: 93 Location: Chennai,India
|
|
|
|
Answers .....
2.Comp is binary storage ... Comp-3 is hexadecimal storage
3.100 bytes
5.only one value at a time
6.Explain gives the access path to the SQL calls
9.Will point to the first record after the selection criterions are made.
Thats all i know .... |
|
Back to top |
|
|
kavitha81
New User
Joined: 21 Nov 2006 Posts: 6 Location: bangalore
|
|
|
|
Hi,
I think when we give "open cursor",it will load the cursor with records. |
|
Back to top |
|
|
kgumraj
Active User
Joined: 01 May 2006 Posts: 151 Location: Hyderabad
|
|
|
|
To add....
1. There is no such limit in terms of size it can be coded upto 999999 variables.
2. Comp takes 4 bytes and comp3 takes 1 byte for every 2 characters.
6. Explain gives the SQL execution path. i.e, the query can be excecuted in many ways but Db2 takes the best path. To know that you need to give EXPLAIN during bind.
7. Db2 module, you mean for the complete project. if so it is like this, One module/ Project has one plan. Each program has one DBRM which yields one Package
8. package concept is more effient. cause you can Compile and bind only that subprogram when you change any code in that. |
|
Back to top |
|
|
|