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
- 10317 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
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
is it compulsory commitment control in journal?
Explain the function done by data manager?
What is check constraint in db2?
What is precompiler in db2?
Explain about open switch business continuity software?
What are db2 tables?
What is bind plan?
What is dbrm library?
Why select is not preferred in embedded sql programs?
What is bind package and plan in db2?
What is bind in db2?
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?
What is runstats and reorg in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
