Re: we are using Aldon Lifecycle Manager for System i - how to create a file conversion pgm

CL is a poor choice for your needs...

Looking at the example (ACMSUSER/USEREXIT(DATACNV)

DCL &OBJNAME *CHAR 10
DCL &OBJLIB *CHAR 10
DCL &SAVNAME *CHAR 10
DCL &SAVLIB *CHAR 10

&OBJLIB/&OBJNAME is the new version of your file without data.
&SAVLIB/&SAVNAME is the old version of your file with your data.

You can use the INSERT part of chuck's SQL example, but you'll have to
create the statement dynamically and run it using PREPARE and EXECUTE
or just EXECUTE IMMEDIATE.

wSQLstmt = 'insert into ' + %trim(objlib) + '/' + %trim(objname)
+ '(fld1, newfld2, fld5)
+ ' select fld1, fld2, fld3 '
+ ' from ' + %trim(savlib) + '/' + %trim(savname)


HTH,
Charles

On Wed, Apr 4, 2012 at 5:51 PM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:

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 is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.