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>"
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.
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?
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.