Link to home
Start Free TrialLog in
Avatar of Virginia Brost
Virginia Brost

asked on

Outputting the records an iSeries file to individual files to be downloaded to Excel

I have an iSeries PF file containing several records.  In order for the individual records to be imported into an imaging system, I need to be able to output each individual record to a file and then download the file either to a pdf or Excel format.  The file name for each record needs to contain it's key structure.  Is there a way to do this?
Avatar of Alan Varga
Alan Varga
Flag of United States of America image

Please post a sample.
Avatar of Virginia Brost
Virginia Brost

ASKER

An example of the iSeries file format is as follows.  The file has 14 fields, 6 of the fields are part of the unique key.  Partial example of the contents of one of the records:
USERID: value "SALL" (KEY field #1)
POLICY: value "XYXA0123456" (KEY field #2)
EFFECTIVE DATE: value 20160101 (KEY field #3)
REPORT NBR: value 07 (KEY field #4)
CLIENT name: value "XYX COMPANY"
STATE id: value 07 (Key field #5)
Client id: value "123abc123"

We need each record in this file to be outputted to individual files whose file name contains the value of the POLICY, EFFECTIVE DATE and REPORT NBR data fields.  In the above example, the file name would be "XYXA0123456 20160101 07.xlsx".
SOLUTION
Avatar of Alan Varga
Alan Varga
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Gary Patterson, CISSP
Gary Patterson, CISSP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Split:
-- Gary Patterson (https:#a42239064)
-- Alan Varga (https:#a42126911)


If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

MacroShadow
Experts-Exchange Cleanup Volunteer