DSXchange

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

Yes, from Tools-->Data Set Management.

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.

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.
where $DSHOME is the home directory of your DataStage installation.

If you want to delete it programatically use this command in a command stage in sequence / after job subroutine.
where $DSHOME is the home directory of your DataStage installation.[/quote]

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

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

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,

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

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>

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.

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.

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.

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.

You need to enter the command as ./orchadmin.

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