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
senthilt1
Participant
Posts: 134 Joined: Mon Nov 19, 2007 2:17 am
Post
by senthilt1 » Wed Feb 13, 2008 6:35 am
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 » Wed Feb 13, 2008 6:59 am
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
Posts: 785 Joined: Thu Jul 28, 2005 8:58 am
Post
by balajisr » Wed Feb 13, 2008 7:05 am
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 » Wed Feb 13, 2008 7:23 am
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 » Wed Feb 13, 2008 7:30 am
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 » Wed Feb 13, 2008 3:38 pm
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 » Thu Feb 14, 2008 2:06 am
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
Posts: 785 Joined: Thu Jul 28, 2005 8:58 am
Post
by balajisr » Thu Feb 14, 2008 3:24 am
Time to mark the post as resolved.