RE: Writing into Files from Stored Procedures

Art, I mentioned MQ as an example of a non-database service that can run within the engine. If the OP uses C or Java within the engine he could write his query results out to a file. As you pointed out, there could be a performance penalty. The more complex solution would be to buffer the result set in to a queue to be written so that the database doesn't get caught up in file i/o. Since the original OP indicated that this was to be a short term, temporary solution, the easiest thing to do would be to write a java based stored procedure in the engine. Why Java? Because the same solution would be more portable than ESQL/C. -G From: art.kagel@gmail.com Date: Wed, 6 May 2009 10:17:36 -0400 Subject: Re: Writing into Files from Stored Procedures To: marc.aurele.severus@gmail.com CC: informix-list@iiug.org ER can definitely handle most ETL needs when you define the replicant. MQ is just a data queue for IPC. Whatever app you place at the other end of the queue will have to perform the data manipulation to insert the data in the target. Only problem is the MQ Datablade may not be certified for IDS 9.30, IB it first came out for 9.40. You are aware that 9.30 is very out-of-date and no longer supported by IBM? You should be upgrading to 11.50 (or at least 10.00) but maybe that's what this is all about. If so you could run the MQ datablade on the target server and write a C UDR for the triggers to call to place data onto the MQ for consumption by the target. More ideas.... Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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 Wed, May 6, 2009 at 5:03 AM, <marc.aurele.severus@gmail.com> wrote: Tanks a lot for your answers. I'm running version 9.30 on AIX 5.1. I forgot to add a piece of information : the source database and the destination database don't have exactly the same format. A conversion will be necessary : some fields will be discarded ; some fields will be merged ; some other fields will be added. So I'm not sure to be able to use ER or MQ ..... _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ Hotmail® has a new way to see what's up with your friends. http://windowslive.com/Tutorial/Hotmail/WhatsNew?ocid=TXT_TAGLM_WL_HM_Tutorial_WhatsNew1_052009