Select statement fetches only one row from table..make sure ur program do

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

Question Posted / nadeem

8 Answers
21040 Views
I also Faced
E-Mail Answers

Answer Posted / nadeem

Select statement fetches only one row from table..make sure
ur program doesn fetch multiple rows..cursor is the only
way to fetch multiple rows to my knowledge..

Is This Answer Correct ?

5 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to retrieve rows from a db2 table in embedded sql?

1391

What is ibm db2 database?

1006

How do you eliminate duplicate values in db2?

1192

What is an instance in db2?

1034

What is null value in db2?

1026

What is the difference between cursor and select statement?

1103

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1061

What is schema in db2?

1022

What is the maximum size of a char data type in db2?

1010

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1148

Define check constraint.

1078

What is query_cache_limit?

970

List out the data types available.

1153

What is check constraint in db2?

1090

Explain how can you do the explain of a dynamic sql statement?

1125