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


Please Help Members By Posting Answers For Below Questions

How to create db2 table in mainframe?

625


How many databases can be created inside an instance in db2 ?

590


What is null in db2?

567


How do I change the column size in db2?

583


How do I add a column in db2?

585






What is the reason behind not using select * in embedded sql programs?

597


What is concurrency?

702


Which components manage deadlocks in db2?

601


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?

7478


What is a collection in db2?

575


Comment whether the cursor is closed during commit or not.

662


How do I create a view in db2?

596


What are the benefits of using the db2 database?

656


How to create backup table in db2?

634


What is rct?

744