Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 25 Apr 2003 @ 14:55:48 GMT


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


Subj:   Re: Perl and teradata
 
From:   Jason Fortenberry

Assuming you are familiar with Perl, you should download the DBI driver for Teradata (version 1.12 is good) from CPAN.

Then in your Perl script do something like this:

use DBI;
my $dbh = DBI->connect(
"dbi:Teradata:[IP address here]",
      "[username here]",
      "[password here]")
      or die;

$sth = $dbh->prepare("Select * from tableX");
$sth->execute();

Then run through your return set with:

while ( @row = $sth->fetchrow_array ){
do something;
}

--Jason Fortenberry



     
  <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