How to resolve -502 sql code in DB2?

Answers were Sorted based on User's Feedback



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

Answer / kk

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?..

Answer / anandrao

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

Is This Answer Correct ?    10 Yes 1 No

Post New Answer

More DB2 Interview Questions

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  


Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,


What is dbrm?

0 Answers  


How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,






What is the maximum size of a char data type in db2?

0 Answers  


What is commit in db2?

0 Answers  


Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,


Which isolation level provides maximum concurrency?

0 Answers  


What is check constraint. Explain with example.

0 Answers  


How to check last update on table in db2?

0 Answers  


What is ibm db2 client?

0 Answers  


Categories