Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 15 Dec 2005 @ 16:42:12 GMT


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


Subj:   BTEQ output and delimited text file
 
From:   Hassinger, Bill

I am having trouble with BTEQ output. I am trying to output a pipe delimited text file and BTEQ always puts a blank line as the first record. Am I missing a SET parameter?

     BTEQ script:
     .Logon loginid, password
     .Set Echoreq off
     .Set Titledashes off
     .Set Separator '|'
     .Set Format off
     .Set Null ''
     .Export REPORT File = 'c:\zzzzz.txt'
     select
     county (title ''),
     poccounty (title '')
      from xxx.yyy;
     .Export Reset
     .Logoff
     .Quit

     OUTPUT:
        |      (blank record)
     081|001
     012|023
     050|091
     035|009
     047|055
     073|088
     006|012

Bill H



     
  <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: 27 Dec 2016