what is difference between Static call and Dynamic call?
How does it function?
Answer / girish kumar
STATIC CALL DYNAMIC CALL
1. call with in the program is 1. call outside of the prog
called static call is called dynamic call.
2. Main program and sub program 2. Main program and sub-
both are stored in same load program stored in
module. different load
modules.
3. It will reserve some space to 3. It doesn't reserve
sub-program before the space for sub-prog
execution. before the execution
By the load module we can identify weather static
call or dynamic call, both main and sub programs stored
in same load module that is main program.
Is This Answer Correct ? | 8 Yes | 2 No |
Outputs of explain are with matchcols = 0. What does this signify?
What does reorg do in db2?
what is a plan and how do you refer the plan in the program?
Update command
Explain various types of locks in db2?
When Can you be sure that a query will return only one row?
What are union and union all?
How do I delete a column in db2?
define clustering index.
What is Call attach facility? How does it work?
Where could you look if you had a question about whether a column has been defined as an index?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?