Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Finding data types in views
From:   Geoffrey Rommel

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

  <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