> Thanks to both of you for your answers.
>
> @Roman: Is there a way to tell if a field is NULL without reading it?

Depends on what level you want this info.

- In SQL you can add IS NULL clause to the WHERE conditions.

- On the API level you can check the sqlind field of the XSQLDA/XSQLVAR
structure

- On JDBC API level you use ResultSet.wasNull(...) call.

Roman