Re: How to Restore AS400 data to SQl Server -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Rob - gotta do it!!

<verndor response>
As one of "those" we have a product called RPG2SQL Integrator - it's an SDK for handling data on remote SQL-based database systems from your RPGLE programs. Look at our site at http://www.rjssoftware.com or call us at 888.rjs.soft for more information.
</verndor response>

Regards
Vern

BTW, I guess I'm the primary developer of the iSeries end of things, now.

rob@xxxxxxxxx wrote:

Normally it's done one of two ways.
1 - Search for JDBC and use a JDBC connection to transfer data. Craig Pelkie wrote an article in the July/August 2005 Volume 8, Number 4 edition of iSeries 400 Experts Journal entitled "Using Java to access Microsoft SQL Server from RPG".
2 - Use the SPENDMONEY command and buy one of the tools who should be offering their solutions on the list any second now...
(Vendors - I have no problem with that and did not mean to infer that I do.)

Other options are more cryptic and may involve something like exporting your DB2 files to stream files (like tab delimited) and them attempting to import those into SQL Server. I would think the loss of column definitions etc would be less than desirable.

Rob Berendt

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.