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