RE: Calling program from BPCS pgm

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.