Archives of the TeradataForum

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

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

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>>