Archives of the TeradataForum

Message Posted: Mon, 01 Mar 2010 @ 17:39:52 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

JK

	<Prev	Next>		<<First	<Prev	Next>	Last>>