Teradata::SQL version 0.03 ========================== 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 connections -- 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; INSTALLATION Ordinarily, you will need root access to install this or any Perl module. Before installing, define an environment variable named TDLOGON. This should be a user ID on the Teradata server that is able to select from DBC views. If you wish, you can also define one named TDDB that names a Teradata database in which you are able to create and drop tables. This will be used in "make test". export TDLOGON=server/user,password export TDDB=my_work_database # Optional Then, run the following: perl Makefile.PL make make test make install DEPENDENCIES This module requires: Perl version 5.6.0 or later a C compiler CLIv2 At present, the module has been tested only on Solaris, MP-RAS, and Windows 2003 Server. The Windows support is incomplete; see WINNOTES. Those who are able to test it on earlier versions of Perl or other platforms are welcome to collaborate. COPYRIGHT AND LICENSE This module is placed in the public domain. It can be freely copied and redistributed under the same terms as Perl itself. Copyright © 2005 Geoffrey Rommel