How do you send an BTEQ abort msg to your JCL

[Rmayott]

I need to send an abort code to my JCL from a SQL script used in a Teradata Data Warehouse application so the condition code is not '000' in order to alert the submitter that the job did not complete normally. Is there a BTEQ command to accomplish this or any other way of doing it?

Thanks

 

[GORYN]

Have you tried to use such as example:
___________________________________________
insert database.table
(
CustID,
...
)
SELECT
CustID
...
FROM TEMP;

.IF ERRORCODE > 0 THEN .QUIT 12
_____________________________________
and catch the errorcode in your JCL

regards
Francois

 

[Rmayott]

Thanks Goryn. John Hall suggested the same approach and it worked well.

Thanks for responding.

Bob