Routine for deleting Dataset

srini.dw · Post by **srini.dw** » Mon Feb 09, 2009 12:46 am

Hi guys,

I need to write a PX routine for deleting a dataset, I know command to delete dataset .,e Orchadmin delete.

But can you please guide me to write a routine for deleting a datasets.

Thank you,

richdhan · Post by **richdhan** » Mon Feb 09, 2009 1:50 am

Hi,

Use the CommandExecution or Routine Activity in the sequencer to delete the dataset.

HTH
--Rich

srini.dw · Post by **srini.dw** » Mon Feb 09, 2009 2:55 am

Thanks for the response,

but I need to write a PX routine to delete a dataset.

Thank You,

richdhan · Post by **richdhan** » Mon Feb 09, 2009 3:23 am

Hi Srini,

There are 2 ways of deleting the dataset. The dataset management utility and the other is the orchadmin. Since orchadmin is a command line utility all you need is a shell script. It does not require a PX routine.

HTH
--Rich

srini.dw · Post by **srini.dw** » Mon Feb 09, 2009 6:02 am

Hi,
Thank you for response,

Since we do not have Unix in Windows 8.1 Server, we cannot run a shell script.
What we need is from Perl script how to run Orchadmin command.?

Any suggestion will be great.

Thank you,

DSguru2B · Post by **DSguru2B** » Mon Feb 09, 2009 3:01 pm

I think you can. You have MKS Toolkit installed which comes with the product. You can run shell's with it.

chulett · Post by **chulett** » Mon Feb 09, 2009 3:22 pm

Or just put the commands in a ".bat" or "batch" file, the Windows equivalent of a shell script.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 09, 2009 4:26 pm

srini.dw wrote:Thanks for the response,

but I need to write a PX routine to delete a dataset.

Thank You,

No you don't.
If you must have a routine, it must ultimately invoke orchadmin command.
There is no other safe way to delete a Data Set.

srini.dw · Post by **srini.dw** » Mon Feb 09, 2009 10:55 pm

Guys, thanks for the response

1. Since i cannot tell me client to install MKS Toolkit , we cannot use Shell script.
2. Our server is in Windows, for deleting a dataset should i use Server routine or Parallel routine. Both will work ?
3. We have Perl script in our server, iam thinking of running a Perl script with Orchadmin command, please let me know will this work.
4. Any other options do i have.

Thank you,

ray.wurlod · Post by **ray.wurlod** » Tue Feb 10, 2009 4:58 am

The client has MKS Toolkit. It installs with Enterprise Edition on Windows.

chulett · Post by **chulett** » Tue Feb 10, 2009 8:53 am

Why the heck would you need a Perl script to run an orchadmin command? Just... run it, in a perfectly normal script or batch file.

srini.dw · Post by **srini.dw** » Wed Feb 11, 2009 4:33 am

Thanks for response,

My design.

Job Activity --> Execute Command Activity

In Execute Command Activity in command option i gave orchadmin delete and in parameters i passed the path.

Iam getting the below error.

Delete_Seq..JobControl (@DEL_DS): Executed: orchadmin delete C:/Temp/t_1234_2009-02-10_99_extr.ds
Reply=1
Output from command ====>
'orchadmin' is not recognized as an internal or external command,
operable program or batch file.

Please let me know any other solution.

Thank you,

ray.wurlod · Post by **ray.wurlod** » Wed Feb 11, 2009 5:13 am

Learn about PATH.