Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 21 Feb 2007 @ 16:09:23 GMT


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


Subj:   Re: BTEQ - export string with CRLF
 
From:   Geoffrey Rommel

  255 characters which is a BTEQ limit.  


Recent versions of BTEQ have relaxed this limit to 65531. Check your manual, or download a more recent version from the patch server.


  Do you know how to force BTEQ to read CRLF or any workaround that might be used?  


Unfortunately, it seems that BTEQ (or field mode?) translates your CRLF's to blanks. Ugh! Maybe ".export data" would work. Or this:

     #!perl
     use Teradata::SQL;
     $dbh = Teradata::SQL::connect("dbc/bogart,bacall");
     $sel = $dbh->open("select your queries here...") or die "huh?";
     while (@text = $sel->fetchrow_list) {
       #--- Print the data without modification.
        print "$text[0]\n";
     }
     $sel->close;
     $dbh->disconnect;


     
  <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