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
What is ibm db2 client?
What is an instance database?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is a plan and package in db2?
Define db2 and its databases?
What is drop table?
What is cascading rollback?
What is dbrm?
can we view the access paths created by dbrm ? how ? thx
What is declare cursor?
What is runstats utility in db2?
Which isolation level provides highest data integrity?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is with ur in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?