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.
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
Mention the location where the output received from explain statement is stored.
What is a cursor in programming?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is cursor stability in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Highlight all the advantages that are attached to a package.
What does a deadlock mean in DB2?
What is clone table?
Define db2 and its databases?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What does runstats do in db2?
What is rct?
How to find the number of rows in a db2 table?
What is a db2 collection?
What is the use of db2?