Hi,
I need to drop a number of fields off each record in a file and be left with the new format under the old file name.
eg input file is called ext/file1 and has four columns, after the process drop 2 colums, i still have a file called ext/file1 with just the two remaining fields.
I have no idea how to keep the file name, or if this is even possible.
As usual, any suggestions would be gratefully recieved, thanks in advance.
Regards,
John Fitz
Dropping Columns off a sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 72
- Joined: Tue Feb 05, 2008 4:38 am
-
- Participant
- Posts: 72
- Joined: Tue Feb 05, 2008 4:38 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Each column in the record schema has a Drop On Input property that you can use to specify that that particular column does not get read into the job.
This is only true in the parallel job Sequential File stage.
This is only true in the parallel job Sequential File stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.