Tweet
I am attempting to move data back and forth between our AS/400 and a UNIX box using ODBC. Has anyone done this successfully? We are using an ETL tool from Ardent to extract data on the UNIX side now but we are replacing our UNIX transaction system with an AS/400 but our Data Warehouse will remain UNIX running Informix database. Any help would be appreciated. Thanks Steve
-
-
UNIX to AS/400 ODBC
I would suggest that for moving large chunks of data back and forth, ODBC is the wrong tool. Check out http://www.starquest.com for info on UNIX - AS/400 file transfers. Dave -
UNIX to AS/400 ODBC
I agree that, in general, bulk operations should be used on bulk data. FTP is an inexpensive option if the data can be used in that form from both sides. If the data needs manipulation, JDBC is generally a more viable option than ODBC for non-Windows platforms. A more expensive but possibly worthwhile solution is a DRDA gateway. A major benefit is that all of these are more or less cross platform standards that leave your options open for the future. You may also want to search the forum; as you might expect, this sort of question has made the rounds before. Joe Sam Joe Sam Shirah - jshirah@attglobal.net Autumn Software - Consulting/Development/Outsourcing Just the JDBC FAQs: http://www.jguru.com/faq/JDBC Going International? http://www.jguru.com/faq/I18N .Comment
-
UNIX to AS/400 ODBC
Thanks Dave, I checked out StarQuest and I was pleasantly surprised to see Client Access for UNIX OS. That may be the way to go. SteveComment
Comment