At 03:17 PM 26/02/2004 +0200, you wrote:

>Hi again,
>
>Helen, thank you for the explanation about GDSCODE. What's the
>relation between GDSCODE and SQLCODE? Which one should I prefer?

Both! SQLCODE is a kind of "generic" exception, while GDSCODE pinpoints
each specific exception. Dmitry has done quite lot of work on improving
the information you get with the GDSCODE so, if you have to choose,
generally choose the GDSCODE. (You get both in the error status vector).

Some of the SQLCODEs are not errors at all, just information or warning
messages, so you don't get GDSCODEs with them. The negative ones are the
exceptions.

/hb