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

What are db2 tables?

How do you concatenate the firstname and lastname from emp table to give a complete name?

Which catalog table stores referential constraints?

what is the differences between spufi and qmf and which is better?

What is the difference between CS and RR isolation levels?

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

what is difference between Plan and Package

What is package in db2 mainframe?

How can we define a table? How can we apply SEARCH ALL on it ?

What is the purpose of the DSNC transaction ?

What is phantom read in db2?

What is reorg and runstats in db2?

For more DB2 Interview Questions Click Here