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 sqlca?
How to check last update on table in db2?
What is phantom read in db2?
What is the difference between bind and rebind in db2?
What is ibm db2 connect?
Explain in brief how does db2 determine what lock-size to use?
What is db2?
How can we retrieve the total number of records in RPG & CLLE?
How can you do the explain of a dynamic sql statement?
What is scrollable cursor in db2?
What do you mean by cursor?
What is multi row fetch in db2?
What is the maximum length of sqlca?
How many databases are there?
What is null indicator in cobol db2?