There is also the option of using the UNSAFE_NULL=yes precompilor option.
This will allow you to receive NULL fields, (it emulates V6 behavior) but it
is NOT good practice either. The use of indicator variables is the best
practice.
Rick
<jblazquez_at_my-deja.com> wrote in message news:7kaajq$dbe$1_at_nnrp1.deja.com...
>
>
> > Why do we have to use _special_ (indicator) variables?
> > Is not there any possibility to manage only with host ones?
> >
>
> You must use indicator variables only if query can return null values
> for a column. With null values in a column the only elegant way to do it
> is with the use of indicator variables. You know in C there isn't any
> null value for datatypes int, char, etc.
>
> If you query non null fields you don't need it.
> If you query nullable fields you can map nulls to data values with NVL
> function... but this is not good programming practice.
>
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Jun 17 1999 - 23:50:35 CDT
