Use of this operator requires some knowledge of ODBC and how it works. For example, ODBC drivers use an ODBC initialization file (odbc.ini) to provide information on its connection to the data source and to specify data handling options. Using an initialization file makes it easy to configure unique options for your system. Therefore, you do not need to specify very many options manually when defining the ODBC operator. On UNIX systems, you can edit the initialization file directly. On Windows systems, a graphical interface is available.
Use the following specifications and attributes to the ODBC operator in a Teradata PT job script.