Re: HPL - is there a back door?

From: tao36@aol.com (Tao36) > >I am porting one of our software products from the Oracle world to >Informix. Welcome! >A portion of our product consists of loads of flat files to the database. >Table >sizes run into the 10's of GB range. > >First, I am assuming that HPL is my only load option given the size of the >tables. I'm new to Informix so if I am wrong about this please let me know. HPL will be the best option for loading *big* tables. As a rule of thumb, if there are less than 10000 rows, don't bother. (Doesn't sound too applicable in your case, but I thought I'd mention it.) >Second, I have numerous load jobs. They are currently in sql*loader >(Oracle) >format which is similar to the dbload format in Informix (i.e. command >file, >etc.). Is there a way I can convert my existing Oracle loads to run in HPL >without having to sit in front of the HPL gui for the next 2 weeks >inputting >record layouts and dragging the mapping arrows around? I mean it's a really >nice tool if you are just building your database, but in this case it's >going >to drive me nuts. Fear not! Help is at hand. Head over to http://www.iiug.org and check out the software downloads. In particular, there's a directory called lsdw, which contains shell scripts that allow you to populate the onpload database quickly. It is a little blunt (and entirely unsupported), but I think it'll save you plenty of time. It works for me. HTH. Good luck! ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com