How to resolve -502 sql code in DB2?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a collection in db2?

584


Explain various types of locks in db2?

693


How can we read records for specific member in CL? AND rpg?

235


Explain about cursor stability?

623


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6862






What are the benefits of using the db2 database?

662


How do I add a column in db2?

596


Outputs of explain are with matchcols = 0. What does this signify?

619


What is bind plan?

615


Explain in detail about buffer manager and its functionalities?

565


What is the difference between dbm cfg and db cfg file in db2 ?

1009


What is difference between alias and synonym in db2?

645


What are packages in db2?

599


Mention the location where the output received from explain statement is stored.

630


What is cobol db2?

570