Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 17 Nov 2005 @ 15:44:09 GMT


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


Subj:   Yet another Perl interface for Teradata
 
From:   Geoffrey Rommel

I recently uploaded the following module to CPAN. Please note that this is freeware, is available to any Perl user, and does not require a preprocessor. I shall probably withdraw Teradata::BTET eventually.

Teradata::SQL is a Perl interface to Teradata SQL. It does not attempt to be a complete interface to Teradata -- for instance, it does not allow asynchronous requests or PM/API sessions -- but it should be sufficient for many applications. The syntax is similar to that of DBI, but this is not a DBI module. Both BTET and ANSI sessions are supported.

A SIMPLE EXAMPLE

     $dbh = Teradata::SQL::connect("dbc/bogart,bacall");
     $sth = $dbh->open("select * from edw.sales");
     while ( @row = $sth->fetchrow_list ) {
        ... process the row ...
     }
     $sth->close;
     $dbh->disconnect;

PREREQUISITES

This module requires:

     Perl version 5.6.0 or later
     a C compiler
     CLIv2 (Note: no preprocessor is required)

At present, the module has been tested only on Solaris and MP-RAS. Those who are able to test it on earlier versions of Perl or other platforms are invited to collaborate.



     
  <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