I am getting a error multiple row fetched while executing a
Cobol-DB2 program.How can I solve it without using a cursor.

Answer Posted / nk

Try using one of the group functions, for example, MAX or
SUM.

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is access path in db2?

562


Explain the contention situations caused by locks?

589


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.

1234


What is dbrm library?

578


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

644






What is difference between isnull and coalesce?

618


What's The Percentage Free Space ?

768


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1897


What does reorg do in db2?

574


What is bind plan?

608


Where do you specify them?

681


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2685


What is dbrm?

636


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6831


Explain about mirror activator disk mirroring?

558