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

Further research has shown that there is an interactive message that is
displayed when issuing CHGPF from a 5250 session:

"Change of file APPACHLOG may cause data to be lost. (C I) "

This interactive message is not handled in WDSC.

It doesn't appear that a change of this nature can be handled in WDSC and
must be handled with a 5250 session.

Does anyone know of a way that WDSC (or even RDP) handles this?



-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On
Behalf Of Mark S. Waterbury
Sent: Monday, September 19, 2011 11:26 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for
System i & iSeries
Subject: Re: [WDSCI-L] 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

--
This is the Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries (WDSCI-L) mailing list To post a message
email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.