Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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


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


3 Answers   Cognizant,

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this i want to receive duplicates...

1 Answers   UST,

why should we bind the DB2 program . What if we did not BIND a BD2 program ??

9 Answers   Infosys, TCS, Xansa,

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

3 Answers  

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,

What is load replace in db2?

0 Answers  


6 Answers  

What is the use of reorg in db2?

0 Answers  

What is cobol db2?

0 Answers  

What does the sqlcode of -818 pertain to?

3 Answers  

what happend with out using Commit,when closing cursor and program?

5 Answers   CSC,

What is nvl in db2?

0 Answers