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

Posted in 2008

Plugge, Joe R. — Tue, 14 Oct 2008 13:28:29 -0500 — source: Usenet: comp.databases.informix

I stand corrected .... ________________________________ From: Uday Kale [mailto:udayk@us.ibm.com] Sent: Tuesday, October 14, 2008 1:21 PM To: Plugge, Joe R. Cc: informix-list@iiug.org; informix-list-bounces@iiug.org; jeff.filippi@itdataconsulting.com Subject: 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.com> "Plugge, Joe R." <JRPlugge@west.com> Sent by: informix-list-bounces@iiug.org 10/14/2008 01:12 PM To <jeff.filippi@itdataconsulting.com>, <informix-list@iiug.org> cc Subject RE: PeopleSoft - Issue with "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