DB2

IBM DB2

IBM DB2 Mainframe connectivity using TD native router

It is possible to use native router in TD for connectivity to IBM's DB2 on Mainframe.
Having a native router means there is no need to install a database client on your machine.
In that case, TD offers all connectivity using the default TD runtime.

What most people don't know, Gupta created a product named SQLHost in the past.
This tool, installed on the Mainframe, could be used by the default TD routers.
Gupta no longer owns and sells the product, the company which currently updates and sells the product is XLSGlobal.

Team Developer still is able to use the native router to connect to SQLHost.

Below an example of SQL.ini for connectivity to IBM DB2 Mainframe:

[win32client]
clientname=Win32Client
connecttimeout=5
setzerolengthstringstonull=on

[win32client.dll]
comdll=sqlws32

[win32client.ws32]
serverpath=DB2SERVD,MF01.eur.tld,1001/SQLHDEV
serverpath=DB2SERVT,MF01.eur.tld,1002/SQLHTEST
serverpath=DB2SERVP,MF02.eur.tld,1000/SQLHPROD

For more information about SQLHost, please visit the company's website:

• XLSGlobal SQLHost