Archives of the TeradataForum

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

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

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

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