What are the major differences between dataset and fileset.
Also, help me with which one is best in what conditions.
Differences b/w fileset & dataset. which is best and Y?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is no "best". There is only "the right tool for the job".
Each preserves partitioning and sorted order of data.
Data Sets keep the internal (binary) formats of data. They are intended to be used only with DataStage, and are perfect for staging data between jobs. The operator for both writing and reading Data Sets is copy.
File Sets translate the internal data into (or from) a human-readable format. You have to supply similar Format properties to those you provide for Sequential File stage. They are intended to be able to be read from (and, perhaps, written to) by other applications. The operator for writing a File Set is export and for reading a File Set is import (the same operators as are used for Sequential File).
Each preserves partitioning and sorted order of data.
Data Sets keep the internal (binary) formats of data. They are intended to be used only with DataStage, and are perfect for staging data between jobs. The operator for both writing and reading Data Sets is copy.
File Sets translate the internal data into (or from) a human-readable format. You have to supply similar Format properties to those you provide for Sequential File stage. They are intended to be able to be read from (and, perhaps, written to) by other applications. The operator for writing a File Set is export and for reading a File Set is import (the same operators as are used for Sequential File).
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.