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?
Please post a sample.
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".
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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