Archives of the TeradataForum

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

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

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>>