This was related to -811 sqlcode, In a COBOL DB2 program
which accesses employee table and selects rows for employee
'A', it should perform a paragraph s001-x if employee 'A'
is present. In this case it gets -811 sqlcode, but still it
process the paragraph s001-x. What could be wrong in my
code.
Answer Posted / karamveer
-811 will come because you have the multiple record fetched by your query. But still your para is stored because first record from your query resultset is fetched and processed. -811 is error but it will not abend your program and it runs fine. You need to build query which result unique record.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is consistency token in db2?
What is db2 bind?
What is db2 catalog database?
Define declaration generator (dclgen).
What is cursor in dbms?
How do you select a row using indexes in db2?
Explain the contention situations caused by locks?
How do I delete a table in db2?
What is cursor stability in db2?
Name the lockable units in DB2?
What is a trigger in the db2 database?
What is check constraint in db2?
what is the responsibility of the construction superintendent
What is db2 bind process?
What is release/acquire in bind?