Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Insert using select between two subsytems
How about using DRDA federated wrapper ? ex) insert into target_table select * from source table; drop wrapper drda; create wrapper drda; CREATE SERVER sdldemo TYPE DB2/6000 Version 7.2 WRAPPER DRDA authorization "eseinst1" password "eseinst1" OPTIONS ( NODE 'this', DBNAME 'sample' )... -
DB2 connect to SQL server
Hi, Jaco Did you ever heard DB2 II(Information integrator) ? DB2/Unix(NT,Linux)V8 with II can federate heterogeneous data source ( DB2/390, DB2/400, DB2/Unix, Informix, Oracle, Sybase, MS SQL, ODBC datasource, text, excel, etc..) At DB2/Unix, Using DB2 Single Interface access all federate...
