What error I will get if my select query gives multiple
row while executing a Cobol-DB2 program.How can I solve it
without using a cursor.
Answer Posted / santy
u will get -811 error code.
this will b solve in different way. first u have to find
out y this error comes.
exmple :-
If u r selecting the address of the emp with help of
Name key, then may b same name contain 2 different address,
as per the business need, it may contain 1 defualt address
and other is alternet address.
So as per the business need find out that which address
u want to select, and as per this need u can use one flag
veriable to differentiate these 2 address. make the change
as per above in ur table. with the help of solution u can
solve the above problem without using the cursor.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How to check last update on table in db2?
What is database reorganization?
How many types of page locks can be held in db2?
What is bind package and plan in db2?
What are the contents of a dclmgen?
What is runstats db2?
How can the duplicate values be eliminated from db2 select?
What is image copy in db2?
What is host variable?
What is runstats utility in db2?
What is a bind card?
What are the rules for db2 programming?
How does coalesce work?
Which component is used to execute the sql statements?
Explain about cursor stability?