Re: WDSC CHGPF / CRTPF on existing file not replacing object

Hi, Paul:

That's just the way CHGPF works. First, it compiles the new *FILE definition into QTEMP, then compares that file to the original to figure out what is different, and then does an SQL ALTER TABLE "under the covers."

Try issuing the CHGPF command from a "green-screen" 5250 session, and you will see the same thing.

Are you sure your file is not getting modified? Perhaps the file was "in use" (locked) and that prevented the command from completing? CHGPF requires *EXCLusive use of the object.

Hope that helps,

Mark S. Waterbury

> On 9/19/2011 11:16 AM, paul therrien wrote:

I am trying to compile a PF from WDSC (WDSC 7.0.0) to my library. The file
already exists. So I have attempted to use the CHGPF option. The job runs
on the iSeries but executes a CRTPF to QTEMP and goes no further.



When I prompt the CHGPF is see this as the command this is about to be
executed:

CHGPF FILE(PJTLIB/APREF) SRCFILE(PJTLIB/QDDSSRC) SRCMBR(APREF)
OPTION(*EVENTF)

But when the job runs I get a CRTPF spool file output with this confirmation
message:

* CPC7301 00 Message . . . . : File
APREF created in library QTEMP.



I have looked for configuration options on the CHGPF and CRTPF commands but
have been unsuccessful finding them.

Any help would be greatly appreciated.



Paul



Paul Therrien

Orion South, Inc.

(504) 374-9551

(800) 487-7173; Ext. 551

(504) 368-9768; Ext. 551

<mailto:ptherrien@xxxxxxxxxxxxxxx> ptherrien@xxxxxxxxxxxxxxx