March 12, 2003 at 2:45 pm
Hi,
I would like to know what's the best way to access the data on MainFrame from SQL.
Thanks in advance!
March 14, 2003 at 9:31 am
Assuming your data is in sequential mainframe datasets (flat files), you can create a Data Transformation Services (DTS) package to download and import the datasets into SQL Server tables.
If your mainframe data is in a database (like DB2), there are DTS tasks that can use the ODBC or OLE DB connections to transfer that data to SQL Server.
Note that the DTS FTP task does not understand the mainframe dataset naming conventions. I use the standard Windows FTP (WINNT\system32\ftp.exe) program and an Execute Process task to download my mainframe files.
March 14, 2003 at 9:43 am
In order to connect to your mainframe database, you have to install specific ODBC client in SQL Server machine.
http://www.databasejournal.com/features/mssql/article.php/1756161
http://ourworld.compuserve.com/homepages/Ken_North/odbcvend.htm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply