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 |
What is the reason behind not using select * in embedded sql programs?
What is view db2?
What is an alias and how does it differ from a synonym?
What is drop table?
What is the connection string to connect to the DB2 Database ?
How to solve S0C7 abend with out using DISPlay in 10 mins?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
Define declaration generator (dclgen).
What is iseries database?
what's the error code for Unique Index Violation?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
what is the maximum number of tables that can be joined ?