DSXchange

Hi,

I have some space issue due to which i want to just remove data form a dataset and convert it to ZERO byte DS after loading to a DB table. how we can do this through UNIX/Data stage?

One can remove a dataset from the command line with "orchadmin rm <descriptor>" and one can truncate the dataset with "orchadmin truncate <descriptor>"

Hi,

I just want to convert it to ZERO byte ds not to remove.So i think if i remove data file , it will work? can i fire rm command to remove datafile?

NO, NO and NO.

The .ds file does not contain data, and thus must not be truncated.

Use orchadmin truncate, as Arnd advised, to empty the Data Set of records.

You can also write a dummy job which uses a row-generator to generate one row, then a transform or filter to remove that one row and write to your dataset; that will do the same thing as the command-line would, it creates an empty new dataset.

Thanks Ray.

So Data set truncatation will just remove Data file and will convert data set to a 0 byte file, keeping descriptor file as it is?

ArndW wrote:You can also write a dummy job which uses a row-generator to generate one row, then a transform or filter to remove that one row and write to your dataset; that will do the same thing as the command-line would, it creates an empty new dataset.

even i thought for the same but wanted to know more from UNIX side.

command "orchadmin truncate *.ds" will truncate the dataset?

No, that command will truncate ALL files ending in ".ds" in the current attach point directory

A Data Set consists of a single ".ds" file which points to multiple data, or "segment" files. Even when you truncate a Data Set the ".ds" file retains its pointers to the data files; it is these that are emptied.

can we truncate or delete dataset in windows environment without using job?

Yes, of course, that's what the orchadmin utility is for. Windows or UNIX.

Thanks craig

where do we have to pass orchadmin in windows environment?

The call is the same on UNIX or Windows. The path to the executable is "{DataStage Installation}\IBM\InformationServer\Server\PXEngine\bin"

Thank you somuch ArndW i got it