Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 03 May 2007 @ 12:47:45 GMT


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


Subj:   Re: Generated SQLs getting truncated
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, May 02, 2007 20:24 -->

Sazi,

No sure what I am looking at.

You might try the following in your bteq script right before or after .logon statement so you can see the output in the log file. .errorout stdout

Typically, the . Command will repeat itself in the log file such as the following:

     +---------+---------+---------+---------+---------+---------+
     .errorout stdout
      *** Error messages now directed to STDOUT.
     +---------+---------+---------+---------+---------+---------+
     .width 254
     +---------+---------+---------+---------+---------+---------+
     .errorlevel (3807,3523) severity 0
     +---------+---------+---------+---------+---------+---------+

You might try .width 254 instead of 255 and see if that helps. If not, you might want to post the whole message from your log file so we can see if we can help.

Is this in PC or UNIX? If this is mainframe then you might check your JCL to be sure your length is define correctly where you land your output.


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: 28 Jun 2020