How to Use datasets?

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
skumar
Participant
Posts: 88
Joined: Thu May 25, 2006 5:11 am
Location: Hyderabad

How to Use datasets?

Post by skumar »

Hi all,

Can any one give an idea how to use the datasets?
i am tried with normal procedure but it was giving the following errors.

*** Error executing command: orchadmin describe -s /home/user/EXAMPLE.ds
##I TFCN 000001 00:29:40(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 00:29:40(001) <main_program> The open files limit is 2000; raising to 2147483647.
##E TFDM 000000 00:29:40(002) <main_program> The file identified as '/home/user/EXAMPLE.ds' is not an ORCHESTRATE Data Set descriptor.
##I TCOA 000040 00:29:40(003) <main_program> ERROR: could not describe /home/user/EXAMPLE.ds
dataset descriptor file has unrecognizeable contents.
##I TCOA 000056 00:29:40(004) <main_program> For help, type: describe -help.

Thanks in Advance.

Regards,
kumar.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Does the file exist? How was is created? For this to work, it must - must - have been created with a Data Set stage; it is a common mistake to believe that one can create a Data Set with a Sequential File stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
skumar
Participant
Posts: 88
Joined: Thu May 25, 2006 5:11 am
Location: Hyderabad

Post by skumar »

Hi Ray,

can you please tell me how to create the file?
thanks,
kumar
Prashantoncyber
Participant
Posts: 108
Joined: Wed Jul 28, 2004 7:15 am

Post by Prashantoncyber »

DataStage parallel extender jobs use data sets to
manage data within a job.

can you tell the data flow in job?
skumar
Participant
Posts: 88
Joined: Thu May 25, 2006 5:11 am
Location: Hyderabad

Post by skumar »

Hi prashantoncyber,

Thanks for ur reply but i don't know how to use them i mean how to cretae the .DS files can you expalin it to me?

Thanks,
kumar
vicmania
Participant
Posts: 7
Joined: Tue Sep 12, 2006 10:47 am

Re: How to Use datasets?

Post by vicmania »

Hello,

normally DataStage creates the file. But the directory must exist and the DataStage user needs the according permissions to be allowed to create the file...

Hope this helps

vicmania
skumar
Participant
Posts: 88
Joined: Thu May 25, 2006 5:11 am
Location: Hyderabad

Post by skumar »

Thanks to all for the replies. can any one tell me what is the default path ?plzzzzzzzzz
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

There is no "default path". You must use a Data Set stage to create a Data Set. The File property must be a pathname with the file name ending in ".ds". If you do not provide a pathname, the ".ds" file is created in the project directory. This file is the Data Set control file; the actual data files are created in the directories specified in the configuration file as disk resources.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply