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.
- 4 Answers
- 11113 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
The most common reason is that your COBOL logic is checking the wrong condition or not checking the SQLCODE immediately after the SQL statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sangeethas1985
anybody who has an idea about this, please post answer.
| Is This Answer Correct ? | 0 Yes | 1 No |
What are host variables in db2?
What happens to a cursor after a commit?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What is cursor in dbms?
What is bind plan?
What is a bind in db2?
How do I add a column to an existing table in db2?
What is ibm db2 client?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What DB2 Catalog column tell you when an index needs table reorganized ?
What is innodb buffer pool?
How to view db2 table structure?
COBOL 
