Hi Team,
Please tell me, If i don't declare the cursor in the program
and i have given open and fetch and close, then what error
will get.
Answer Posted / dharani
Db2 return code would be -504 since the cursor is not
declared.
-501 - cursor not opened
-502 - opening cursor which is already opened
-503 - update column not specified in cursor while
declaring the cursor for updating some of the columns in
the table.
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How to create db2 table in mainframe?
How many databases can be created inside an instance in db2 ?
What is null in db2?
How do I change the column size in db2?
How do I add a column in db2?
What is the reason behind not using select * in embedded sql programs?
What is concurrency?
Which components manage deadlocks in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is a collection in db2?
Comment whether the cursor is closed during commit or not.
How do I create a view in db2?
What are the benefits of using the db2 database?
How to create backup table in db2?
What is rct?