multiple rows fetch problem to host variables

swarna bathala · New User Joined: 27 Apr 2009 Posts: 1 Location: hyderabad

Hi,

When i used a select query in a COBOL program to fetch a value in to host variable, if there is a single value corresponding to that select criteria it fetches fine, but when ever there are multiple rows for that select criteria it is showing -811 sql code but also fetching the second qualified row into the host variable.
But when i used the same COBOL code in AIX it is not fetching any rows to the host variable.

Please let me know how mainframe COBOL is handling the code in this situation.

Thanks
Somasekhar Gajjala.

dick scherrer · Posted: Wed Dec 09, 2009 10:24 pm

Hello,

If there is the possibility of returning more than one row, suggest you use a cursor. . .

Craq Giegerich · Posted: Wed Dec 09, 2009 11:38 pm

When you get a error sql code you should never depend on any host variables that may be returned.

sachin_star3 · New User Joined: 30 Sep 2006 Posts: 78 Location: pune

Use the cursor,
Whenever you are dealing with more than one row then you should need to use the cursor,
singltone select query will fetch only the one row.

dbzTHEdinosauer · Posted: Thu Dec 10, 2009 7:12 pm

if your db2 vsn supports mult-row fetch, that is also an option where you do not need a cursor.