Am I correct in understanding that when doing a select on a table I cannot
retrieve a NULL value from the database directly into the variable I'm
selecting into, but I must use an indicator. So for example
EXEC SQL SELECT b INTO :val FROM test1;
will fail if b is NULL, so I must use
EXEC SQL SELECT b INTO :val :val_ind FROM test1;
and then check the value of val_ind. If 0 then val is not NULL is -ve then
it is NULL?
Thanks
Atif