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
- 10286 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 |
Answer / sangeethas1985
anybody who has an idea about this, please post answer.
| Is This Answer Correct ? | 0 Yes | 1 No |
Give the name of some fields form sqlca.
How does the processing of a correlated subquery differ from a non correlated subquery?
Why might full image copies be faster to implement than an incremental image copy?
What is a lock?
how to resolve -818 error. how to see timestamp token in load module and plan
What are the various data types available in db2?
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
what is + sign and -ve sign for sql code ?
Where besides the DB2 catalog is database object information stored by DB2?
What is QUIESCE?
How do you retrieve the data from a nullable column?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
COBOL 
