Page 1 of 1

How to Use datasets?

Posted: Wed Sep 13, 2006 12:02 am
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.

Posted: Wed Sep 13, 2006 1:12 am
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.

Posted: Wed Sep 13, 2006 1:41 am
by skumar
Hi Ray,

can you please tell me how to create the file?
thanks,
kumar

Posted: Wed Sep 13, 2006 3:16 am
by Prashantoncyber
DataStage parallel extender jobs use data sets to
manage data within a job.

can you tell the data flow in job?

Posted: Wed Sep 13, 2006 3:37 am
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

Re: How to Use datasets?

Posted: Wed Sep 13, 2006 4:02 am
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

Posted: Wed Sep 13, 2006 5:07 am
by skumar
Thanks to all for the replies. can any one tell me what is the default path ?plzzzzzzzzz

Posted: Wed Sep 13, 2006 5:27 am
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.