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?




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

Delivered-To: sonny.kim@xxxxxxxxxxxxxx

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.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.