Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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:

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

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023