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
- 10445 Views
- I also Faced
- E-Mail Answers
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
When do you specify the isolation level?
Mention the definition of cobol in varchar field.
What is buffer pool and list some of them?
What is the use of commit in db2?
How many databases are there?
What is a db2 cursor?
What is cursor with hold option in db2?
How do I connect my db2 database to ibm?
What is database manager in db2?
What is the meaning concurrency in the db2 database?
How to take backup of table in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is load utility in db2?
Is db2 a mainframe database?
