Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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
     }
     $rh->close;


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