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
- 10451 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
Explain the function done by data manager?
How to retrieve rows from a db2 table in embedded sql?
What is role in db2?
What kind of database is db2?
Explain about rct in db2?
What is the function of logging in the db2 database?
What is query_cache_limit?
What is the use of reorg in db2?
What is the result of open cursor statement?
Explain correlated sub-queries.
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?
List some fields from sqlca?
What is node in db2?
What do you mean by between and in? Is between inclusive of specified range values?
How to rename a table in DB2 ?
