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?