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
Why db2 is called db2?
How to find schema of a table in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is rebind in db2?
What is cursor with hold option in db2?
How many databases are there?
What is image copy in db2?
Mention the downsides of page level lock.
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
Can you use max on a char column?
What is the maximum number of columns in a db2 table?
How do I change the column size in db2?
Before you give the explain statement, what are the prerogatives?
What are the benefits of using the db2 database?
what is utility for parm lib