Interested to Buy Any Domain ? << Click Here >> for more details...
I am getting a error multiple row fetched while executing a
Cobol-DB2 program.How can I solve it without using a cursor.
- 8 Answers
- 20633 Views
- I also Faced
- E-Mail Answers
Answer Posted / anamika
You cannot use 'Fetch first 1 row only' in a singleton
select in COBOL. Instead u can use 'SELECT TOP <colname>'
to get the first row in the result set.
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
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?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How do you eliminate duplicate values in db2?
How to find the number of rows in db2 tables?
How does a cursor work?
Why db2 is called db2?
How can you do the explain of a dynamic sql statement?
What is copy pending and check pending in db2?
What is the use of value function?
What is difference between isnull and coalesce?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the difference between oracle and db2?
What does db2 blu stand for?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
