Re: Getting SQLERRD[1] from SPL
akent@cix.compulink.co.uk ("Andy Kent") writes:
>You can do this if you have 6.00-on of the engine by using SELECT
>DBINFO(sqlerrd1).
>It was a known and much-criticised shortcoming of 5.00 that you couldn't
>get at the sqlca record. I don't know whether DBINFO crops up
>undocumented in 5.01 or 5.02.
It does not. However, the task can be accomplished in 5.02 by using an
insert trigger to execute a procedure which assigns the serial value to a
global variable that is also defined in the triggering procedure.
>akent@cix.compulink.co.uk (Andy Kent)
>-------------------------------------
>+44 117 974 2815