Re: Help! Looking for Data load utilities

The 7.2 High Performance Loader is very flexible with date formats. I don't know if it's been ported to NT yet since the GUI for it is X-windows based. The HPL has some other warts but the datatype conversion flexibility is excellent. Kenneth L. Shuck Jr. <kenneth_shuck@mail.amsinc.com> wrote in article <33D5BF28.7BBB@mail.amsinc.com>... > Hello, > > We are in the process of moving from Oracle to Informix OnLine Server > 7.2 for Windows NT and are trying to identify a utility which provides > similar functionality to the Oracle SQL*Loader. So far we have examined > the dbload utility and have found it somewhat limited and inefficient. > The main problem is that we have data coming in from several external > interfaces with differing date formats which we need to load into our > database - dbload does not allow us to easily indicate the incoming date > format or provide conversion "on-the-fly" to the Informix standard > internal format. We believe that there may be a way to handle this > problem using the DBDATE environmental variable, but that involves > making changes to the registry which has us a little scared. Does > anyone have any experience dealing with this situation or with any > commercially available data load utilities? Any help is appreciated. > > Ken Shuck >