RE: PeopleSoft - Issue with "truncate" in App Engine

Truncate is logged, but transaction needs to be committed/rolled back immediately. Regds, Uday. "Plugge, Joe R." <JRPlugge@west.co m> To Sent by: <jeff.filippi@itdataconsulting.com> informix-list-bou , <informix-list@iiug.org> nces@iiug.org cc Subject 10/14/2008 01:12 RE: PeopleSoft - Issue with PM "truncate" in App Engine Truncate is not logged, hence not in transaction From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Jeff Filippi Sent: Tuesday, October 14, 2008 12:01 PM To: informix-list@iiug.org Subject: PeopleSoft - Issue with "truncate" in App Engine Question, has anyone used the Informix “truncate table” command inside of App Engine in PeopleSoft. I recommended that the developer use the “truncate table” during processing of a specific process to reduce the runtime. She has tried to put the “commit work” immediately after the “truncate table” command in App Engine, but it has not worked, it is executing another SQL statement after the “truncate table” command and not the “commit work”. Informix 10.00FC4 PeopleTools 8.49.09 Thanks, Jeff Jeffrey J. Filippi Integrated Data Consulting, LLC 104 Cottonwood Dr. Streamwood, IL 60107 630-842-3608 630-497-1762 (Fax) jeff.filippi@itdataconsulting.com www.itdataconsulting.com IBM BUSINESS PARTNER. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

In article <mailman.134.1224008621.874.informix-list@iiug.org>, Uday Kale says... Please don't post MIME. >Truncate is logged, but transaction needs to be committed/rolled back >immediately. Perhaps you meant truncate is logged but can not be used in a transaction. e.g will the following work:- BEGIN WORK ; DELETE FROM TABLE_A WHERE ... ;TRUNCATE TABLE_B ; UPDATE TABLE_C SET ..COMMIT WORK ; My guess, based on SQL server and Sybase, is that it will not work. Please confirm.