In cursor program-1 can we create another cursor program-2
inside the cursor program-1.If yes how/no why ?
Answers were Sorted based on User's Feedback
Answer / lvr_rams
yes it can possible. Multibull cursor we can used.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / truclu
yu can create multiple cursor but with hold...because if
you don't want to lose your row...
| Is This Answer Correct ? | 0 Yes | 1 No |
Describe the elements of the SELECT query syntax?
How do you define a correlated name?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
Why do we need reorg in db2?
What is dclgen in db2?
How to resolve -803 sql code in DB2?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
Can we use select * statement in cobol program without giving field names ???
What is an alias and how does it differ from a synonym?
What is ibm db2 used for?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?