Copy from Dataset

deepag · Post by **deepag** » Wed Jul 18, 2012 10:59 am

Is there any easy way to copy Data from Dataset all records at a time?

ArndW · Post by **ArndW** » Wed Jul 18, 2012 12:07 pm

I'm not sure what you mean by your question, could you perhaps explain in a bit more detail what "all records at a time" means? Datasets are easily defined and copied in DataStage jobs. Do you want to copy the contents at the OS level, without a job?

deepag · Post by **deepag** » Wed Jul 18, 2012 5:58 pm

I am asking as how to copy and paste the data present in dataset at a time.

As far I know, we can copy only one record at a time and paste in other document. My question is : "Is there any way to copy all records of dataset and paste in other document at a time instead of copying and pasting each record"

ray.wurlod · Post by **ray.wurlod** » Wed Jul 18, 2012 6:29 pm

You can use orchadmin to dump the records and a redirection operator ( > )to write them into a file.