dbload alternatives

We are trying to get to a true client/server setup with our Informix environment. This means moving all the 4gl apps off the db engine server to their own machine. The only hurdle I'm running into is dbload. Our app currently is leveraging dbload to deal with fixed length data files and doing some data checking without wholesale rejection like load does. Unfortunately, dbload appears to only come with the engine. Anybody dealt with this or have an option/alternaive?

Download Jonathan Leffler's SQLCMD package from the IIUG Software Repository. One of the utilities in that package, sqlreload, can handle fixed record format files and it will perform partial commits just like dbload does. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, May 29, 2015 at 1:21 PM, <> wrote: > We are trying to get to a true client/server setup with our Informix > environment. This means moving all the 4gl apps off the db engine server to > their own machine. > > The only hurdle I'm running into is dbload. Our app currently is leveraging > dbload to deal with fixed length data files and doing some data checking > without wholesale rejection like load does. > > Unfortunately, dbload appears to only come with the engine. > > Anybody dealt with this or have an option/alternaive? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113f90ea2b14a705173c2e96

An alternative is to write a load program to perform that task. ESQL/C is an excellent tool for that purpose. Sent from my Verizon Wireless 4G LTE smartphone -------- Original message -------- From: Date: 05/29/2015 1:21 PM (GMT-05:00) To: ids@iiug.org Subject: dbload alternatives [35174] We are trying to get to a true client/server setup with our Informix environment. This means moving all the 4gl apps off the db engine server to their own machine. The only hurdle I'm running into is dbload. Our app currently is leveraging dbload to deal with fixed length data files and doing some data checking without wholesale rejection like load does. Unfortunately, dbload appears to only come with the engine. Anybody dealt with this or have an option/alternaive? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.