How to resolve -502 sql code in DB2?

Question Posted / vikram and mangesh

Answers were Sorted based on User's Feedback

How to resolve -502 sql code in DB2?..

hi,

Open cursor already open.try to check the open cursor
giving twice.

Is This Answer Correct ?

13 Yes

1 No

How to resolve -502 sql code in DB2?..

This error occures when you are opening the cursor which is
already open in current session.

Is This Answer Correct ?

10 Yes

1 No

More DB2 Interview Questions

How to find the number of rows in a db2 table?

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

How can you split a table in to exactly half?

What types of tables are there in the db2 database?

Is ibm db2 free?

What are the various isolation levels possible?

what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

Can SQL statements/queries be included in a copybook?

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

What is bufferpool in db2?

Define check constraint.

What is the maximum size of varchar data type in db2?

For more DB2 Interview Questions Click Here