Data Retrieval from DataSet Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
senthilt1
Participant
Posts: 134
Joined: Mon Nov 19, 2007 2:17 am

Data Retrieval from DataSet Stage

Post by senthilt1 »

Hi All,

I am new to Parallel jobs. I tried retrieving the data thro dataset stage, it shows the following error. My file name is dataset1.ds.

Error Message:
dataset1.ds is not an ORCHESTRATE Data. Set descriptor.

But the same fil, if i use seq file stage, its working with same layout.

Please give me the solution for this.

Thanks and Regards,

SKP
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Data sets and Sequential files are different types. What you are trying is like attempting to read an Oracle table with a sequential file stage. You can only read Datasets with the Dataset stage.
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Post by balajisr »

Are you sure that you had created the file using dataset stage? I doubt the file is a valid dataset?
senthilt1
Participant
Posts: 134
Joined: Mon Nov 19, 2007 2:17 am

Post by senthilt1 »

Yes, I am sure, I have created the file as dataset1.ds,

the record is,

101,Michael,States
205,Rhude,Miluwake

like this.....
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Making the name end in ".ds" doesn't create a dataset. Did you write this file with a sequential file stage or a Dataset stage?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If it can be read with a Sequential File stage it was created with a Sequential File stage, or something at the command (operating system) level. It is not a Data Set, which is a parallel structure.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
senthilt1
Participant
Posts: 134
Joined: Mon Nov 19, 2007 2:17 am

Post by senthilt1 »

Thanks a lot Friend, I got it.

Instead writing first to the Dataset, I just started with reading from the dataset by creating the file with .ds. Now its working.

Thanks to everyone of you,

Regards,
SKP
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Post by balajisr »

Time to mark the post as resolved.
Post Reply