Fichero de configuración de la fuente de datos (UNIX y Linux®)

Para configurar las entradas del archivo ' .odbc.ini ' para acceder a la fuente de datos del sistema en su propio sistema Netezza Performance Server, obtenga la siguiente información de configuración del administrador del sistema Netezza Performance Server y sustitúyala por la información del archivo ' .odbc.ini ':

Database

El nombre de la base de datos del sistema en el sistema Netezza Performance Server.

SchemaName

El nombre del esquema dentro de la base de datos especificada en el sistema Netezza Performance Server. Este campo se utiliza para los sistemas Netezza Performance Server que admiten varios esquemas dentro de una base de datos. Si no especifica un esquema, se conectará al esquema predeterminado de la base de datos.

User name

ID de usuario válido para acceder al origen de datos del sistema.

Server name

El nombre de host del servidor o la dirección IP de su sistema Netezza Performance Server.

Password

Contraseña válida para acceder al origen de datos del sistema.

No utilice comillas dobles ni punto y coma en la contraseña.

UnicodeTranslationOption=utf8
;
;  odbc.ini
;
[ODBC Data Sources]
NZSQL = NetezzaSQL


[NZSQL]
;Path of a driver used for database connection
Driver                = /usr/local/nz/lib/libnzodbc.so

;A decription used to identify the database connection properties.
Description           = NetezzaSQL ODBC

;The name of a machine or IP address where the database is located.
Servername            = 127.0.0.1

;The port number to connect.
Port                  = 5480

;The name of a database.
Database              = dev

;The schema in the database. If unspecified, driver connects to 
:default schema for the database.
SchemaName            = sample_schema

;The name of a valid user.
Username              = guest

;The password for  the user.
Password              = password

;Only Select SQL statements will be allowed if this field is checked.
ReadOnly              = false

;When this option is enabled and the application bindtype is same as 
;backend datatype the query performance will be faster. Query 
;performance gain will be achieved only for single select statements 
;(not for batch queries).It also works in case when application bind 
;type is different than backend datatype but there are some
;restrictions on it.
FastSelect            = false

;When set to true, system tables will be included in the available
table list.
ShowSystemTables      = false

;When set to true, use old (2.5) functionality for returning schemas in
SQLTables.
LegacySQLTables       = false

;Specifies login timeout in seconds.
LoginTimeout          = 0

;Specifies query timeout in seconds.
QueryTimeout          = 0

;Specifies date format as follows -
; 1: YMD
; 2: MDY
; 3: DMY
DateFormat            = 1

;When selected, driver treats SQL_C_NUMERIC buffers as SQL_C_CHAR
buffers.
NumericAsChar         = false

;Return SQL_BIT as "1"/"0" when char.
SQLBitOneZero         = false

;When enabled, replaces all occurences of CRLF, CR and LF with a single
space.
StripCRLF             = false

;Specifies level of security on the system
securityLevel         = preferredUnSecured

;Name of the Root CA certificate.
caCertFile            =

;Specifies maximum errors allowed. 0 value means no limit on
loadMaxErrors value.
;loadMaxErrors         = 1

;If value is true, it rounds the data of numeric columns whose
precision exceeds the precision defined.
;loadRoundFraction     = 0


[ODBC]
IANAAppCodePage=4
InstallDir=/opt/odbc32v51
Trace=0
TraceDll=/opt/odbc32v51/lib/odbctrac.so
TraceFile=odbctrace.out
UseCursorLib=0