DSXchange

Hello,

I have designed a job sequencer that loop px job that makes an Oracle jointure and create a dataset with the loop value in the name.(So if the loop runs 5 times i have 5 datasets).
A the end of the sequencer, i have to merge all datasets into one.

Here is my problem\question :

Can i make a purge\truncate of a dataset at the beginning of the process and make appends in a dataset file or do i have to make another job that use a funnel and merge all datasets into one ?
May be there's an unix command to trunc a dataset, no ?

thanks

Hi,

You can use the orchadmin command to truncate the dataset. You can use the orchadmin command in command activity or routine activity.

HTH
--Rich

thank you

command is

orchadmin truncate dataset_file.ds :D