Before using the ODBC operator, you must configure the ODBC initialization file on your platform to designate the DSN (data source name) in 'ODBC Data Sources' to point to the proper data source.
Following is a sample ODBC.ini file for a Solaris client system. It shows data source information for Teradata, ORACLE, and SQLServer data sources.
[ODBC] InstallDir=/usr/odbc Trace=0 TraceFile=/usr/joe/odbcusr/trace.log TraceAutoStop=0 [ODBC Data Sources] testdsn=tdata.so default=tdata.so Teradata=tdata.so Oracle=DataDirect 4.10 Oracle SQLServer Wire Protocol=DataDirect 4.10 SQL Server Wire Protocol [testdsn] [default] [Teradata] [Oracle] Driver=/opt/odbc/lib/ivor818.so Description=DataDirect 4.10 Oracle LogonID=oracle Password=oracle ServerName=DBCName=200.001.001.01 CatalogOptions=0 ProcedureRetResults=0 EnableDescribeParam=0 EnableStaticCursorsForLongData=0 ApplicationUsingThreads=1 [SQLServer Wire Protocol] Driver=/opt/odbc/lib/ivmsss18.so Description=DataDirect 4.10 SQL Server Wire Protocol Database=db LogonID=uid Password=pwd Address=sqlserverhost,1433 QuotedId=No AnsiNPW=No