ODBC for Teradata

[keshav0307]

Can anyone give me a sample of ODBC entry in ODBC.ini file in Linux for Teradata.
how Can i Import an teradata Stored Procedure

[bcarlson]

I haven't done any stored procs with Teradata, but I have done ODBC - we have some Perl programs that use the ODBC libraries to talk to Teradata.

We are on an IBM AIX server, but I would imagine the ODBC ini file would be the same format.

Here's what we have (names have been changed to protect the innocent )

Code: Select all

[ODBC]
InstallDir=/usr/odbc
Trace=0
TraceDll=/usr/odbc/lib/odbctrac.so
TraceFile=/usr/joe/odbcusr/trace.log
TraceAutoStop=0

[ODBC Data Sources]
testdsn=tdata.so
edwdtdf1=tdata.so

[mytdpidname]
Driver=/usr/lpp/tdodbc/odbc/drivers/tdata.so
Description=TD Warehouse Dev
DBCName=10.20.30.40
LastUser=
Username=myuserid01
Password=mypwd123
Database=
DefaultDatabase=

The location of your tdata.so (the shared library object) may be different, so you'll need to find out where you Teradata DBA or sys admin installed the Terdata ODBC drivers on your Linux system. The name in the square brackets is the TDPID, like in the login command:

.login mytdpid/myuserid01,mypwd123

Hope this helps.

Brad.