On 2010-04-27, Atif Jung <atifjung@gmail.com> wrote:
> --0016e6d58ae54607be048535e007
> Content-Type: text/plain; charset=ISO-8859-1
>
> 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
what language is that?