Teradata::SQL ============= 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 The module has been tested on Solaris, MP-RAS, AIX, Linux (SLES and CentOS), Windows 2003 Server, and WinXP. 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. 64-BIT SUPPORT Version 0.10 of the module includes changes intended to support 64-bit operating systems. Testing on 32-bit Linux was successful. On 64-bit Linux, most functions work, but parameterized requests (requests with "?" in the text of the prepared query) do not; they yielded CLI errors of 328 or 350. For now, the only workarounds are to avoid parameterized requests or to compile the module on a 32-bit system and transfer the binaries to a 64-bit system. Help from anyone for this issue will be gladly received. 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