Archives of the TeradataForum
Message Posted: Mon, 01 Mar 2010 @ 17:39:52 GMT
You might check your SQLSTATE set up in your exception handler (or what ever you have set up) and if <>00 - display a message with the PCG_MSG4 to see what was generated, etc.
Here is an example of the processes I do:
IF (Status <> '00000') THEN -- Set reject message and leave SET MESSAGE = 'ABORT: Unable to collect statistics with ''' || Col_Stats_Stmt || ''' (SQLSTATE=' || Status || ').'; LEAVE CollectTblStats; END IF;
Hope this helps.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|