Dear Experts,
We've installed Data Services XI 3.2 on Suse linux 10, we want to use odbc connection for data transfer from OS400 iseries and Sql Server 2005,
We installed data driver 5.3 on data services server, i think next step is updating the odbc.ini file Db2 Wire Protocol, so which informations we need to enter in odbc.ini file, could you please help ?
Here is the odbc.ini file example ;
[DB2 Wire Protocol]
Driver=/usr/sap/data_direct/DataDirect_5.3_Linux64_x86/lib/DAdb223.so
Description=DataDirect 5.3 DB2 Wire Protocol
AddStringToCreateTable=
AlternateID=
AlternateServers=
ApplicationUsingThreads=1
AuthenticationMethod=0
CatalogSchema=
CharsetFor65535=0
#Collection applies to z/OS and iSeries only
Collection=
ConnectionRetryCount=0
ConnectionRetryDelay=3
#Database applies to DB2 UDB only
Database=<database_name>
DefaultIsolationLevel=1
DynamicSections=200
EncryptionMethod=0
GrantAuthid=PUBLIC
GrantExecute=1
GSSClient=native
HostNameInCertificate=
IpAddress=<DB2_server_host>
LoadBalancing=0
#Location applies to z/OS and iSeries only
Location=<location_name>
LogonID=
Password=
PackageCollection=NULLID
PackageOwner=
ReportCodePageConversionErrors=0
TcpPort=50000
TrustStore=
TrustStorePassword=
UseCurrentSchema=1
ValidateServerCertificate=1
WithHold=1
XMLDescribeType=-10
Best Regards