DSXchange

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

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

<moved here from the TX forum>

SURA wrote:...write into a .ds file.

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.

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

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.

In the Data Set Management, output can see some ORCHESTRATE codes, node details etc. I thought of to hack and use that is the aim of my question.

DS User