Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

Answer Posted / marekj

I mean you want to fetch only the first row and the select
statement is correct. You have to use "fetch first 1 row
only" eg.
select name
from peoples
where name like 'A%'
fetch first 1 row only;

Is This Answer Correct ?    15 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the responsibility of the construction superintendent

2151


Mention the location where the output received from explain statement is stored.

1130


What are the contents of dclgen?

1114


What are the benefits of using the db2 database?

1235


Which command is used to connect to a database in DB2 ? Give the Syntax.

1106


Why db2 is called db2?

1051


Explain about cursor stability?

1058


What is the physical storage length of timestamp data type?

1102


What is dclgen (declaration generator)?

1066


How to execute stored procedures?

1135


Explain about rct in db2?

1114


Before you give the explain statement, what are the prerogatives?

1044


How connect db2 database to datastage?

1249


How can you quickly find out the # of rows updated after an update statement?

1052


Define db2 and its databases?

1059