delete dataset

vennam445 · Post by **vennam445** » Sat May 02, 2009 7:50 pm

Hi,
I should delete Dataset after creation.Is there a way to delete it from Datastage?

lstsaur · Post by **lstsaur** » Sat May 02, 2009 8:22 pm

Yes, from Tools-->Data Set Management.

vennam445 · Post by **vennam445** » Sat May 02, 2009 8:49 pm

lstsaur wrote:Yes, from Tools-->Data Set Management.

Hi,
I want to delete it after performing a test on the reject link.I should use a stage do delete the dataset.

vrishabhsagar · Post by **vrishabhsagar** » Sat May 02, 2009 9:53 pm

vennam445 wrote: Hi,
I want to delete it after performing a test on the reject link.I should use a stage do delete the dataset.

If you want to delete it programatically use this command in a command stage in sequence / after job subroutine.

Code: Select all

$DSHOME/bin/orchadmin rm <datasetname>

where $DSHOME is the home directory of your DataStage installation.

vennam445 · Post by **vennam445** » Sat May 02, 2009 10:01 pm

If you want to delete it programatically use this command in a command stage in sequence / after job subroutine.

Code: Select all

$DSHOME/bin/orchadmin rm <datasetname>

where $DSHOME is the home directory of your DataStage installation.[/quote]

Thanks for your reply.How can i find the DSHOME directory?

vrishabhsagar · Post by **vrishabhsagar** » Sat May 02, 2009 10:39 pm

$DSHOME usually be loaded into your environment. Are you using AIX? Try

Code: Select all

echo $DSHOME

vennam445 · Post by **vennam445** » Sun May 03, 2009 2:11 pm

I wrote a shell script to delete dataset.
a=`cat Rejects.txt|wc -l`;
if [ $a -ne 0]
then `rm Result.txt';
exit 1;
fi;

When i execute this script from command line it works fine but not from the after job sub routine.After job subroutine ran without error but the file is not deleted.I am using execute command sequence for the after job sub routine.

Also I have one more issue.Once the file is deleted the job has to abort in the sequence.How can I do that.

Thanks,

lstsaur · Post by **lstsaur** » Sun May 03, 2009 2:53 pm

Please read your manual as to what's a dataset. Either Rejects.txt or Result.txt is not a dataset.

mail2hfz · Post by **mail2hfz** » Sun May 03, 2009 2:56 pm

Try the suggested method, not with "rm" command to delete the datasets. The file you were able to delete is the descriptor file not the data file and you will be left with orphan data files.

If you want to delete it programatically use this command in a command stage in sequence / after job subroutine.

Code:
$DSHOME/bin/orchadmin rm <datasetname>

chulett · Post by **chulett** » Sun May 03, 2009 3:00 pm

vennam445 wrote:When i execute this script from command line it works fine but not from the after job sub routine.

Full not relative paths when you do something like this, never mind the fact that (as noted) it is not the right thing to be doing.

dsedi · Post by **dsedi** » Mon May 04, 2009 3:30 pm

try writing a routine by passing the arguments like the $APT_ORCHHOME directory plus the dataset to be deleted and use the Dsexecute command in the routine.

vennam445 · Post by **vennam445** » Mon May 04, 2009 4:00 pm

I tried to delete the .ds file by going to the path ~/IBM/InformationServer/PXEngine/bin which has the orchadmin file.I tried to execute the orchadmin command from here to delete the file
orchadmin delete filename.ds but I am geting the error orchadmin not found.But when I do the ls command i can see the orchadmin file.

chulett · Post by **chulett** » Mon May 04, 2009 4:22 pm

Not much command line experience, it seems. If you cd to the directory a command 'lives in' then preface it with 'dot slash' i.e. "./orchadmin delete filename.ds" - assuming that syntax is correct. Or fully pathing a command works from anywhere.

lstsaur · Post by **lstsaur** » Mon May 04, 2009 4:27 pm

You need to enter the command as ./orchadmin.

vennam445 · Post by **vennam445** » Mon May 04, 2009 4:58 pm

I tried even ./orchadmin.It doesnt work:(