I have a dataset which has some 400,00 records in it,for my testing purpose i need to create a copy of the data set with a sample of first 200 records from the data set. Can somebody let me know how to do this.
Regards
Kumar
data set
Moderators: chulett, rschirm, roy
Re: data set
I am not sure how much it is possible to fetch part of the records using command line and created it as .ds file. The simple option is use that .ds as a source and in the TFM make it run in Sequence use @OUTROWNUM = 200. So that you can get 200 records which can again write into a .ds file.
DS User
DS User
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: data set
Please be aware that data are never written into the .ds file itself. This file is a descriptor that stores the locations of the segment files in which the data are actually stored. There is one segment file per resource disk directory per node, provided that there are sufficient records to make the full distribution worth while.SURA wrote:...write into a .ds 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.
Re: data set
Ray,I mean to used a dataset file stage to write it.
One more question; can't we hack it to read the part of the records?
Don't as why?
DS User
One more question; can't we hack it to read the part of the records?
Don't as why?
DS User
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do you speak binary? Storage in Data Sets uses DataStage internal format where, among other things, all numeric data are stored in binary format. A Data Set is not intended to be a database (otherwise they would have called it that). A Data Set stores a set of data: a whole set of data.
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.