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 |
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What is page size in db2?
What is clone table?
what is the role of the cursor in db2?
What is db2 connect?
Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam
How connect db2 database to datastage?
What is db2 instance?
What is ibm db2 database?
How do I add a column to an existing table in db2?
How would one remove old reorg information from the DB2 catalog?