Joel -

Can you explain why are you adding new fields in the middle of the record format? In every shop where I have worked [or managed]. we made it a rule to add new fields to the end of the record...

If you are renaming fields and adding new fields to the /end/ of the record layout, you could use CPYF with FMTOPT(*NOCHK) during promotion to promote the data.

However, since you are inserting new fields between existing ones you will definitely need a custom program or a RUNSQL script which needs to be called /after/ promotion which will update the data in the file.

I am also fairly certain that you will need to make a copy of the file /before/ promoting the changes:

1) as an input file for the conversion program, and
2) because I am not sure what happens to the data in the file once the changes have been promoted.

Paul can probably recommend the steps needed to do this within the Aldon CMS - my most recent experience has been with Implementer, not ACMS.

- sjl



"Stone, Joel" wrote in message news:mailman.7538.1333635467.14575.midrange-l@xxxxxxxxxxxx...

Yes there is a shell sample in there, but NO CODE at all, only parms with NO descriptions. The manual has descriptions, but no example code. Im looking for a simple example that I can run with.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul Nelson
Sent: Wednesday, April 04, 2012 5:49 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: we are using Aldon Lifecycle Manager for System i - how to create afile conversion pgm

Look in the library named ACMSUSER. I think there's a sample in there.

Paul Nelson
Office 512-392-2577
Cell 708-670-6978
nelsonp@xxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
Sent: Wednesday, April 04, 2012 4:51 PM
To: 'Midrange Systems Technical Discussion'
Subject: we are using Aldon Lifecycle Manager for System i - how to create
afile conversion pgm

Im trying to write a CL routine to promote a file with fields renamed AND
several fields added into the middle of the record format.


I am looking for an example data conversion program. If you have one you
could share to get me started, that would be great!


1) CPYF *nochk to copy the data
2) CPYF *map to move the data into the proper fields


Do I use *LIBL for the "from" lib?

Do I use &OBJLIB for the "target" lib?


They provide a sample CL with parms only, not much regarding what they
contain.

Thanks



______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs
Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________

This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2019 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].