PeopleSoft - Issue with "truncate" in App Engine

[Jeff Filippi]

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.f...@itdataconsulting.com

www.itdataconsulting.com

IBM BUSINESS PARTNER

 

[Plugge, Joe R.]

Truncate is not logged, hence not in transaction

 

---

[Uday Kale]

Truncate is logged, but transaction needs to be committed/rolled back immediately.

Regds,
Uday.
"Plugge, Joe R." <JRPl...@west.com>

"Plugge, Joe R." <JRPl...@west.com> Sent by: informix-l...@iiug.org 10/14/2008 01:12 PM

To <jeff.f...@itdataconsulting.com>, <inform...@iiug.org> cc Subject RE: PeopleSoft - Issue with "truncate" in App Engine

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

[Plugge, Joe R.]

I stand corrected ….

 

---

[dcrun...@aim.com]

In article <mailman.134.12240086...@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.