Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 02 May 2007 @ 19:33:37 GMT


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


Subj:   Re: Generated SQLs getting truncated
 
From:   Afreen, Sazia

Thank you very much for your reply. We tried the .set width before the export within the script. Still getting the truncation at the same point like,

     Collect Statistics Using SAMPLE Column ACCOUNT_SID on
     DB.S2_ACCT_PROD_SUBSCR

From the error log, we are getting the followings:

     .LOGOFF
      *** You are now logged off from the DBC.
     +---------+---------+---------+---------+---------+
     .SET SESSION TRANS BTET
     +---------+---------+---------+---------+---------+
     .SET FORMAT ON
     +---------+---------+---------+---------+---------+
     .SET WIDTH 255
     +---------+---------+---------+---------+---------+
     .TITLEDASHES OFF
     +---------+---------+---------+---------+---------+

Are these set commands working?


Thanks



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