Read a flat file and aggregate the value and write to another file

[iris.west2015]

Hi,

I have a flat file. I need to aggregate the value of a particular field and then write this record into another flat file. Please share some sample codes.

[DeadManWalks]

Re: Read a flat file and aggregate the value and write to another file

Do you know SQL?

[tomliotta]

Re: Read a flat file and aggregate the value and write to another file

I have a flat file. I need to aggregate the value of a particular field...

A "flat file" normally wouldn't have a "particular field". Each line (or each 'record') would be a single 'field'.

Can you clarify just what you actually have to work with?

[UserName10]

Re: Read a flat file and aggregate the value and write to another file

Here's one way. Change the specifics of course.

     FFILEA   IP  F      32            DISK
     FFILEB   O   F      32            DISK
     IFILEA    
     I                                       10  150AMOUNT
     C                     ADD  AMOUNT    TOTAL  150
     OFILEB   T        LR
     O                         TOTAL     15

[DeadManWalks]

Re: Read a flat file and aggregate the value and write to another file

Why even bother to summarize a table to stuff into another table. I bet you are then using this table to put into another table. Skip this altogether and just use SQL.

[RBOrrell]

Re: Read a flat file and aggregate the value and write to another file

Homework seems pretty simple - is this an RPG II class?