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