Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Regarding Dynamically collecting the Stats
From:   John_Wight

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.


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023