AUTOSYS JOB FAILED WHILE DELETING AND INSERTING RECORD IN ORACLE

shuchidxt_gmail_com — Wed, 16 Jan 2019 15:37:11 GMT

I have a code to simply delete record and then insert records. I don't get any error but got a warning of

"WARNING: Character expression will be truncated when assigned to character column LOB_CD." which should not make job to fail.

makes failed my job. Why?

PROC SQL;
DELETE FROM xx.xx;
DELETE FROM xx.xy;

QUIT;

PROC SQL;
INSERT INTO xx.xx SELECT * FROM ZZ.XX;
INSERT INTO XX.XY SELECT * FROM ZZ.XY;

QUIT;

Re: AUTOSYS JOB FAILED WHILE DELETING AND INSERTING RECORD IN ORACLE

r_behata — Wed, 16 Jan 2019 16:00:03 GMT

On the Autosys environment the Success/ Failure criteria are defined by how you handle the sas return codes.

Typically on a Unix / Linux environment post execution this code would give you a return code 1 due to the warning. You may handle this return code from the Shell script( in case you are using any ) to mark this job as success despite the warning.

However, I would highly recommend to correct this warning as it appears that there is a type mismatch while inserting the data from your Proc SQL Insert.

topic AUTOSYS JOB FAILED WHILE DELETING AND INSERTING RECORD IN ORACLE in SAS Programming

AUTOSYS JOB FAILED WHILE DELETING AND INSERTING RECORD IN ORACLE

Re: AUTOSYS JOB FAILED WHILE DELETING AND INSERTING RECORD IN ORACLE