Re: Dynamic SQL in PRO-C (type 3), problem with NULL

What you shoud do is actually declare a variable as short int.

your select then looks something like follows:

exec select column_name into column_value:null_ind;

Now if you retrieve a select, null_ind is set to -1. This is the correct way to code for Nulls using PRO*C.

Riccardo D.S. wrote in message
<38E49951.D6D2CB0A_at_aleniasystems.finmeccanica.it>...
>I use e dynamic SQL statment (pro c - type 3 ) to estract
>the value of single column and put it in the host-variable.
>When the return of query is Null the SQL statment go in error .
>Is it possible when this occur continue the process?
>Now use the NVL function to return a particulat string
>or number when the value is NULL. I prefer ignore the select
>when tha value is Null and continue to other select.
>
>Thanks,
>Sorry for my english...
>
>I'm italian
>
>Dott. Riccardo Di Stefano
>Alenia Marconi System s.p.a.
>Rome - Italy
>
Received on Tue Apr 04 2000 - 00:00:00 CDT