Archives of the TeradataForum
Message Posted: Wed, 11 May 2005 @ 13:34:18 GMT
| Subj: | | Re: Need a program to test Unix ODBC install for Teradata |
| |
| From: | | Geoffrey Rommel |
| | I need something independent of Perl to test the ODBC program. | |
You do have the Teradata ODBC driver installed on AIX, right? It comes with a sample program named 'adhoc'. You'll find it under
/usr/odbc/samples/C/ or a similar directory.
| | Has anyone used the Perl DBI and DBD::ODBC with Teradata? Did you get it to work? | |
Yep, it works. Decimal numbers of 16 digits or more will be converted to float and lose precision. You may have to set up some environment
variables in your Perl programs. I don't have the exact names handy, but they would be something like this:
$ENV{ODBCLIB} = "/usr/odbc";
| 
