Hi! Did you put "WITH NC" at end of your SQL statement? If not then try. If work file is not for multiple users then I would create a front-end CL program to Clear Physical File Member (CLRPFM). Then you don't have to worry about Reorganize Physical File Mbr (RGZPFM) on work file later. Good Luck! Sonny Kim -----Original Message----- From: bpcs-l-bounces+sonny.kim=itg-global.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+sonny.kim=itg-global.com@xxxxxxxxxxxx] On Behalf Of Daniel Wilkins Sent: Tuesday, December 13, 2005 3:25 PM To: bpcs-l@xxxxxxxxxxxx Subject: [BPCS-L] Calling program from BPCS pgm I have a program in the BPCS environment that is simply posting production and then clearing a work file and I placed a call to an RPGLE program that I created and my program runs correctly and the production posts correctly but for some reason the work file is not clearing. The work file is being cleared by a simple SQL statement. Take out the call to my program and the production posts and the work file clears perfectly. Is there something I need to do to my program for it to be used within a BPCS program? Thanks, Daniel -- This is the SSA's BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. Delivered-To: sonny.kim@xxxxxxxxxxxxxx DISCLAIMER: This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to which they are addressed. This communication may contain material protected by privilege. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please reply back to sender advising that you have received the e-mail in error.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.