Example of an odbc.ini file for DB2 UDB on AS/400 or z/OS

This is an example of a DSN to access DB2 UDB for AS/400 or z/OS:

;;DB2 UDB AS/400 or z/OS DSN template
;;
[dcdb2udbas400]
Driver=/<ODBC_install_dir>/lib/<driver_library>
IPAddress=
TcpPort=
Location=
Collection=
SecurityMechanism=0
WorkArounds2=131072
;;
;; Advanced options
;;
AddStringToCreateTable=
AlternateID=
CatalogSchema=
IsolationLevel=CURSOR_STABILITY
CharsetFor65535=0
ReportCodePageConversionErrors=0
ApplicationUsingThreads=1
UseCurrentSchema=1
WithHold=1
;;
;; Bind options - for DSNs used with bind20 utility
;;
GrantExecute=1
GrantAuthid=PUBLIC
DynamicSections=64
;;
;; Optional Failover options 
;;
LoadBalancing=0
AlternateServers=
ConnectionRetryCount=0
ConnectionRetryDelay=3