Re: Converting AS/400 Data to HP9000 HPUX Informix

AKRoche wrote: > > Does anyone have any experience migrating an AS/400 database to Informix? > The database exists on both the AS/400 and in Informix. The tables are > identical in format. There is no referential integrity at the database > level on either machine - that's currently all handled at the application > level. > > Our biggest challenge appears to be just getting the data onto the 9000. > We tried FTP but had problems with packed numeric fields. We currently > have a manual process that "works" but requires that we download each file > from the AS/400 to a PC and then upload the file from the PC to the 9000. OK, first, you have to unload the tables as binary data. If I understand the problem correctly, your database is in EBCDIC and has COMP-3 data types. (Packed and Zoned numeric fields.) If you FTP from AS/400 or a Mainframe it automatically converts from EBCDIC to ASCII for you unless you specify the session to be Binary. Once you have the data down, you will need to write some simple ESQL/C routines for the data conversion. (I think I have some hacked code lying around.) If you have the 7.2 engine, there was supposed to be an utility to convert the data for you. If not, heck I'll write one and market it. ;-) Hope this helps. -Mikey