Re: Can I load EBCDIC data to INFORMIX DB?

On 30 Jan 1996, Henry Nesbit wrote: > Oracle converts IBM mainframe (EBCDIC) data to ASCII at load time so a > prior conversion is not necessary when sending data from an IBM mainframe > to a UNIX platform. Two questions: > 1) Will the Informix load program > accept EBCDIC data for loading? 2) If yes to 1), does > this include support for packed (COMP-3) EBCDIC data? NOTE: EBCDIC > file is transferred in binary mode to UNIX platform so it is not > converted to ASCII going cross-platform. > > Thanks... > - > HENRY NESBIT HKRM57A@prodigy.com > Henry, dbload (in my version SE 5+, and I suspect in others), which comes bundled with your Informix db utility, requires an Ascii file. You'll have to use dd if you have Unix or whatever utilities your system provides to make the conversion. Watch out for translation of blanks and nulls. You may want to check the results or segments thereof using hd or od to reassure yourself that nothing is lost or added in translation. As for the rest, dbload is very handy and offers numerous features including error reporting for moving large gobs of data into your tables. BTW, when you do, be sure to turn logging off; otherwise you may find system performance beginning to degrade. Hope this helps, Nick ********************************* Nick Nobbe, Library of Congress NLS/BPH mail: nnob@loc.gov *********************************