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
- 10258 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
Which isolation level provides highest data integrity?
What is explain in db2?
Why db2 is called db2?
What is the meaning concurrency in the db2 database?
What is nvl in db2?
How do I add a column to an existing table in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What are db2 objects?
What is declare cursor?
How do you pull up a query which was previously saved in qmf?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is bind in db2?
What is null indicator in db2?
What is a cursor in programming?
