Paul,

>
> Have you looked at the XSQLVAR struct? Every column has an
> sqlind flag
> which is set to -1 if the column is not null. The API guide discusses
> this in more detail in the Chapter 'Working with Dynamic SQL' in the
> section about SQL datatype macro constants.
>
>

Yes, i know that, but to my understanding, sqlind is used when the data
is effectively NULL, but not when the underliying field has a "Not Null"
constraint, my question was badly formulated, i know sqlind and the
sqltype+1 trick..

Saludos,
Ignacio J. Ortega