DB2

From Team Developer SqlWindows Wiki
Revision as of 11:59, 29 September 2017 by DaveRabelink (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

IBM DB2


Contents


Pointer2.png IBM DB2 Mainframe connectivity using TD native router Pointer.png

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: