Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 11725 Views
- Cap Gemini, Verizon, I also Faced
- E-Mail Answers
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
Is db2 relational database?
What is the difference between bind and rebind in db2?
What are the prerogatives?
Can there be more than one cursor open for any program?
Which are the db2 tools to protect integrity of the database?
What is a system catalog table in db2?
What is phantom read in db2?
How do I import a csv file into db2?
How does db2 sample database connect?
Explain about dbrm.
Explain the benefits you can get from mainframe connect?
How can we read records for specific member in CL? AND rpg?
Before you give the explain statement, what are the prerogatives?
How to check table size in db2 sap?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
