We have moved to www.dataGenX.net, Keep Learning with us.

Thursday, February 07, 2013

.odbc.ini EXAMPLE file


This is a Part of  ODBC Configuration in DataStage tutorial.
This is Example file of .odnc.ini


[ODBC Data Sources]
TESTDB=DataDirect DB2 Wire Protocol Driver
DB2 Wire Protocol=DataDirect DB2 Wire Protocol Driver
dBase=DataDirect dBaseFile(*.dbf)
Informix=DataDirect Informix

Informix Wire Protocol=DataDirect Informix Wire Protocol Driver
Oracle=DataDirect Oracle Driver
Oracle Wire Protocol=DataDirect Oracle Wire Protocol Driver
SQLServer Wire Protocol=DataDirect SQL Server Wire Protocol Driver
Sybase Wire Protocol=DataDirect Sybase Wire Protocol Driver
Teradata=DataDirect Teradata
Progress Wire Protocol=DataDirect Progress OpenEdge Wire Protocol
Progress OpenEdge=DataDirect Progress OpenEdge
Progress SQL92=DataDirect Progress SQL92
Text=DataDirect TextFile(*.*) Driver

[TESTDB]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdb223.so
Description=DataDirect DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=NULLID
Database=
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=meusi.vipa.uk.ibm.com
IsolationLevel=CURSOR_STABILITY
Location=TESTDB
LogonID=
Password=
Package=
PackageOwner=
TcpPort=3201
WithHold=1

[DB2 Wire Protocol]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdb223.so
Description=DataDirect DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=OS/390 and AS/400 (Remove for DB2 UDB)
Database=DB2 UDB (Remove for OS/390 and AS/400)
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=DB2 server host
IsolationLevel=CURSOR_STABILITY
Location=OS/390 and AS/400 (Remove for DB2 UDB)
LogonID=
Password=
Package=DB2 package name
PackageOwner=
TcpPort=DB2 server port
WithHold=1

[dBase]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdbf23.so
Description=DataDirect dBaseFile(*.dbf) Driver
ApplicationUsingThreads=1
CacheSize=4
CreateType=dBASE5
Database=/scratch/DataDirect_5.2/odbc/demo
IntlSort=0
Locking=RECORD
UseLongNames=0
UseLongQualifiers=
DataFileExtension=DBF
ExtensionCase=UPPER
FileOpenCache=0
LockCompatibility=dBASE

[Informix]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMinf23.so
Description=DataDirect Informix driver
Database=db
LogonID=uid
Password=pwd
ServerName=informixserver
HostName=informixhost
Service=online
Protocol=onsoctcp
EnableInsertCursors=0
GetDBListFromInformix=0
CursorBehavior=0
CancelDetectInterval=0
TrimBlankFromIndexName=1
ApplicationUsingThreads=1

[Informix Wire Protocol]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMifcl23.so
Description=DataDirect Informix Wire Protocol driver
Database=db
LogonID=uid
Password=pwd
HostName=informixhost
PortNumber=1500
ServerName=informixserver
CancelDetectInterval=0
TrimBlankFromIndexName=1
ApplicationUsingThreads=1

[Oracle]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMor823.so
Description=DataDirect Oracle driver
ApplicationUsingThreads=1
ArraySize=60000
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=
OptimizeLongPerformance=0
Password=
ProcedureRetResults=0
ServerName=Oracle host
UseCurrentSchema=1

[Oracle Wire Protocol]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMora23.so
Description=DataDirect Oracle Wire Protocol driver
ApplicationUsingThreads=1
ArraySize=60000
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
HostName=Oracle server
LocalTimeZoneOffset=
LockTimeOut=-1
LogonID=
Password=
PortNumber=Oracle server port
ProcedureRetResults=0
SID=Oracle SID
UseCurrentSchema=1

[SQLServer]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMmsss23.so
Description=DataDirect SQL Server Wire Protocol driver
Database=db
LogonID=uid
Password=pwd
Address=sqlserverhost,1433
QuotedId=No
AnsiNPW=No

[Sybase Wire Protocol]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMase23.so
Description=DataDirect Sybase Wire Protocol Driver
ApplicationName=
ApplicationUsingThreads=1
ArraySize=50
Charset=
CursorCacheSize=1
Database=db
DefaultLongDataBuffLen=1024
EnableDescribeParam=0
EnableQuotedIdentifiers=0
InitializationString=
Language=
LogonID=
NetworkAddress=Sybase host,Sybase server port
OptimizePrepare=1
PacketSize=0
Password=
RaiseErrorPositionBehavior=0
SelectMethod=0
WorkStationID=

[Text]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMtxt23.so
Description=DataDirect TextFile(*.*) Driver
AllowUpdateAndDelete=0
ApplicationUsingThreads=1
CacheSize=4
CenturyBoundary=20
Database=/scratch/DataDirect_5.2/odbc/demo
DataFileExtension=TXT
DecimalSymbol=.
Delimiter=
FileOpenCache=0
FirstLineNames=0
IntlSort=0
ScanRows=25
TableType=Comma
UndefinedTable=GUESS

[Teradata]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/ivtera23.so
Description=DataDirect Teradata
AccountString=
CharacterSet=ASCII
DBCName=<Teradata_server>
Database=
EnableDataEncryption=No
EnableLOBs=Yes
EnableReconnect=No
IntegratedSecurity=No
LoginTimeout=20
MapCallEscapeToExec=No
MaxRespSize=8192
Password=
PortNumber=1025
PrintOption=N
ProcedureWithSplSource=Y
ReportCodePageConversionErrors=0
SecurityMechanism=
SecurityParameter=
ShowSelectableTables=Yes
UserID=

[Progress Wire Protocol]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/ivoe1023.so
Description=DataDirect Progress OpenEdge Wire Protocol
DatabaseName=<database_name>
EnableTimestampWithTimezone=1
HostName=<Progress_server>
LogonID=
Password=
PortNumber=<Progress_server_port>

[Progress OpenEdge]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/ivpro1023.so
Description=DataDirect Progress OpenEdge
DatabaseName=<database_name>
EnableTimestampWithTimezone=1
HostName=<Progress_server>
LogonID=
Password=
PortNumber=<Progress_server_port>

[Progress SQL92]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/ivpro923.so
Description=DataDirect Progress SQL92
DatabaseName=<database_name>
HostName=<Progress_server>
LogonID=
Password=
PortNumber=<Progress_server_port

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