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
- 11624 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
What is check constraint in db2?
What are catalog tables in db2?
what is db2 restart?
Mention the definition of cobol in varchar field.
What is the syntax for FETCH in DB2 ?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What are host variables in db2?
How can the duplicate values be eliminated from db2 select?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is db2? Explain.
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the clustering index in the db2 database?
What are packages in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Give the name of some fields form sqlca.
