Archives of the TeradataForum

Message Posted: Mon, 12 Apr 2010 @ 14:20:11 GMT

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

If you use Perl with module Teradata::SQL, the result set from any request can be read with the open/fetchrow_list/close sequence. This includes the output from Select, Show, and Help. You could therefore do something like this:

     $dbh = Teradata::SQL::connect("mrbig/user,password")
         or die "Could not connect";

     $rh = $dbh->open("help columns edw.view1"); while (@cols = $rh->fetchrow_list) {
        print "column type: @cols\n";
        # Your processing here
     }
     $rh->close;

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