Re: Looking for BASIC example of using embedded SQL for retrieving field value

Just to repeat, you should check SQLSTT after every exec sql statement.
See my sample earlier.

Also, since you cannot do a 'select into' on a prepared statement you will
have to use a cursor.

There are some who say if you are using a cursor in SQL you are using it
wrong. I am NOT in that camp.

Under normal circumstances I do think it's rather silly to use a cursor
for a single row fetch. But if you really have a need for a generic
utility like you are trying to do then you'll have to go that route.


Rob Berendt