[ODBC Data Sources] NZSQL = NetezzaSQL [NZSQL] Driver = /usr/local/nz/lib64/libnzodbc.so ;Driver = /usr/local/nz/lib/libnzodbc.so Description = NetezzaSQL ODBC Servername = servername.example.com Port = 5480 Database = SYSTEM Username = username Password = password ;Only Select SQL statements will be allowed if this field is checked. ReadOnly = false FastSelect = false ShowSystemTables = false ;When set to true, use old (2.5) functionality for returning schemas in SQLTables. LegacySQLTables = false 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 ;Possible fixes for translation error that didn’t work. UTF16 was the solution. ;TranslationDLL= ;TranslationName= ;TranslationOption= [ODBC] IANAAppCodePage=4 InstallDir=/opt/odbc32v51 Trace=0 TraceDll=/opt/odbc32v51/lib/odbctrac.so TraceFile=odbctrace.out UseCursorLib=0