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
- 10253 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
What are the contents of dclgen?
What is data manager?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is db2 instance?
Explain the contention situations caused by locks?
What are types of indexes?
What are the rules for db2 programming?
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 null indicator in db2?
What is the physical storage length of timestamp data type?
What is a bind card?
When reorg is used?
what are bind concepts in db2 cobol?
What is temporal table in db2?
What is a db2 schema?
