DataStage - Delete Dataset

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 383 of 390

Delete Dataset

How to Delete Dataset in Datastage Parallel Jobs?

Total Answers and Comments: 4

Last Update: September 04, 2009 Asked by: ramanjulu.m

Sponsored Links

Best Rated Answer

—

Submitted by: Brajesh Singh Bhadoriya

Deletingg dataset can be done in two ways:
1. Orchasmin utility in Unix
2. Dataset management tool

To use Orchadmin in unix, one has to set environment for DataStage by setting following environment variables:

1. PATH
2. LIBPATH
3. DSHOME
4. APT_ORCHHOME
5. APT_CONFIG_FILE

After doing this, one can use orchadmin rm <dataset name with extension> to delete dataset.

To delete dataset from DataStage Designer, one can use dataset management tool.

Regards
Braj.

Above answer was rated as good by the following members:
geekbeeram

May 19, 2009 02:29:52

Abhijain

Member Since: December 2007 Contribution: 20

RE: Delete Dataset

There are two ways to perform this operation.

1. Orchadmin command rm
2. Datastage Management tool.

Is this answer useful? Yes | No

June 26, 2009 12:50:37

aladap12

Member Since: August 2007 Contribution: 5

RE: Delete Dataset

We can delete dataset using DataStage designer Client.

Tools -> DataSet Management

We can select dataset and delete it.

Is this answer useful? Yes | No

August 19, 2009 14:35:31

skchaithu_82

Member Since: August 2009 Contribution: 1

RE: Delete Dataset

Chaithu: After working with the dataset pass zero records to the dataset
or
Using datastage manager delete dataset by using dataset management utility.

Is this answer useful? Yes | No

September 04, 2009 05:25:18

Brajesh Singh Bhadoriya

Member Since: December 2006 Contribution: 13

RE: Delete Dataset

Deletingg dataset can be done in two ways:
1. Orchasmin utility in Unix
2. Dataset management tool

To use Orchadmin in unix one has to set environment for DataStage by setting following environment variables:

1. PATH
2. LIBPATH
3. DSHOME
4. APT_ORCHHOME
5. APT_CONFIG_FILE

After doing this one can use orchadmin rm <dataset name with extension> to delete dataset.

To delete dataset from DataStage Designer one can use dataset management tool.

Regards
Braj.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank