Thanks for responding to my question and sorry for the delay
in answering your reply.
Informix ESQLC (9.2.1 ) has functionality that allows you to get the
a previously excecuted sql statement.
/* there can be more than 1 exception, the "1" in the following example
refers to the 1st exception" */
EXEC SQL get diagnostics exception 1
:_srvrname = SERVER_NAME, :_sqlstate_code = RETURNED_SQLSTATE,
:_message = MESSAGE_TEXT, :_messlen = MESSAGE_LENGTH;
This would place the DB Server name, Error message text (if any) and the
of the error message into the respective host variables.
This statement would compile and run under informix but fail
when compiled with ecpg (3.1.0/PostgreSQL 7.4.1) with the following
"test.pgc:19: ERROR: syntax error at or near "diagnostics" "
Compilation command: "ecpg -c -C INFORMIX test.pgc"
I have attached test.pgc
Thanks to all,
Peter Eisentraut wrote:
>>I am currently thinking about porting
>>Embedded esql/c code from informix to
>>PostgreSQL. It there any plans on incorporating
>>the "EXEC SQL GET DIAGNOSTICS" functionality?
>It's already there. What is missing?
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
Description: text/plain (692 bytes)
In response to
pgsql-interfaces by date
|Next:||From: Goulet, Dick||Date: 2004-01-16 20:01:20|
|Subject: ECPG on WinDoze|
|Previous:||From: Dave Cramer||Date: 2004-01-12 13:28:25|
|Subject: Re: ECPG and EXEC SQL GET DIAGNOSTICS|