Very Computer

I am using a 'select into' command that populates a number of host
variables.  One of these variables is a number.  If the number is populated
with any number (inlcuding 0) the command works fine.  But, if the number is
not populated, I get a -305 SQLCODE when the 'select into' command is
executed and none of the host fields get populated.
If I use a fetch instead and get the -305 SQLCODE error, the rest of the
host fields will get populated.
I would rather use the select into statement.  Then I wouldnt have to
declare/open/fetch/close a cursor just to read in a record.  Is there a way
I can do this?

Thanks
Doug

have you tired using an indicator variable set to -1 ? Take a look at the
app/dev guide.

A -305 is an error and not a warning.  You shouldn't rely on any value to be
set, neither in the FETCH nor in the SELECT INTO case.

Besides that, you should give db2 an indicator variable to work with.  Have a
look at the application development duide for the details on that.

--
Knut Stolze
DB2 Spatial Extender
IBM Silicon Valley Lab