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 |
how to resolve -811 sqlcode .give clear explaination
What is the use of runstats in db2?
is it possible to get -811 error when you use cursors. why?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What keyword does an SQL SELECT statement use for a string search?
Where can you declare a cursor in a cobol-db2 program?
What are foreign keys?
What is db2 command?
How to resolve -803 sql code in DB2?
What types of tables are there in the db2 database?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?