Answer Posted / srini
Declare cursor instead of singleton select,as the query you
are running has multiple records.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is role in db2?
Is ibm db2 free?
What is table space in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Is db2 relational database?
What is check constraint in db2?
What does reorg do in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the connection string to connect to the DB2 Database ?
what is the sqlcode -501
How does coalesce work?
Give a brief description of db2 isolation levels?
Can we update view in db2?
What is precompiler in db2?
What is rct?