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

How to resolve -502 sql code in DB2?

Question Posted / kk

Answer Posted / kk

hi,

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

Is This Answer Correct ?

13 Yes

1 No

Please Help Members By Posting Answers For Below Questions

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2951

What is an instance database?

1059

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2222

What are union and union all?

986

What is dclgen (declaration generator)?

1066

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1112

What is database reorganization?

1135

What does db2 plan contain?

1031

Is it possible using max on a char column?

1146

What is performance tuning db2?

1068

What is db2 instance?

1110

What is null indicator in cobol db2?

1070

Mention the various locks that are available in db2.

1045

Explain about mirror activator disk mirroring?

1018

How do we specify index to include or not during bind process.

2132