message PROC SQL

jplarios — Thu, 15 Apr 2010 14:45:52 GMT

I am creating a small stp web app.
I created some PK in a small table. The thing is, when an insert happens the STP will fail if there is a integrity constraint violation. Is there some PROC SQL OPTION or something that when the violation happens I can take this 'error return code' and send a message instead of failing?

jp

Re: message PROC SQL

DataShare — Fri, 16 Apr 2010 08:40:13 GMT

after proc sql you can check for the errors in the proc sql execution as
%if &sqlrc ne 0 %then
%do;
%let ReturnCustomError=Error During insert ;
%return;
%end;

/* SQLXRC - contains the DBMS-specific return code that is returned by the Pass-Through Facility. */

topic Re: message PROC SQL in Developers

message PROC SQL

Re: message PROC SQL