Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 23 Jul 2004 @ 14:41:56 GMT

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

Subj:   Re: UNIX/Teradata output redirection
From:   Victor Sokovin

  I am running a BTEQ (a simple Teradata select) from a UNIX script and redirecting the output (stdout) to a file (bteq > "/home/user/report.txt").  

  My problem is that the results are truncated after column 72. Would anyone know of a way to get UNIX to redirect to full text length (beyond 72 characters) of the query's results?  

You might need to issue

     .SET WIDTH 

in your BTEQ script first. To check what your UNIX settings are issue

     echo $COLUMNS .



  <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: 23 Jun 2019