Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 10291 Views
- I also Faced
- E-Mail Answers
Answer Posted / srivalli janapati
Your code must not be using the CURSOR concept and NOT
handling the abend properly.When atleast CURSOR is not
being used in the code,there should be alteranative code to
handle when query resulted in retrieving multiple rows.
-811: is basically the SELECT query resulted in retrieving
more than a Row
Meaning,the resultant query must be retrieving more than a
row,and tried to push all the resualtant rows at a time for
the processing.COBOL-DB2 program can't handle this
situation as it expects a row at a time and then ABENDS.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
What is ibm db2 client?
What is drop table?
What is sqlca’s maximum length?
what is a corelated subquerry?
What is access path in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How do I create a view in db2?
Mention some fields that are a part of sqlca.
What is dbrm?
How to find schema of a table in db2?
What is the physical storage length of time data type?
How do I add a column in db2?
What is database reorganization?
How does coalesce work?
What kind of database is db2?
