Re Naming DataSets

edison · Post by **edison** » Wed Sep 01, 2010 2:35 pm

Iam running a job with dataset name test1.ds, after the job run the dataset name need to be change to test.ds in the same path specified.How can i do in orchadmin,help me out.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 01, 2010 4:33 pm

You can not rename, but you can copy then delete.

This will temporarily require double the volume of the Data Set on your resource disk(s).

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Sep 02, 2010 2:01 am

If you are only interested on the .ds file, you can rename it in Unix itself.

ajay.vaidyanathan · Post by **ajay.vaidyanathan** » Thu Sep 02, 2010 5:14 am

You can use DataSet Management in the TOOLS to achieve this. But the exact functionality for which you are doing this is not going to get resolved. In DataStage you cannot rename a DataSet. You can only copy it and reuse it using the Orchadmin cmd.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 02, 2010 5:42 am

Sainath.Srinivasan wrote:If you are only interested on the .ds file, you can rename it in Unix itself.

That is ill-advised, because the segment files' names on the resource disk include the descriptor file name.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Sep 02, 2010 6:54 am

ray.wurlod wrote:
Sainath.Srinivasan wrote:If you are only interested on the .ds file, you can rename it in Unix itself.
That is ill-advised, because the segment files' names on the resource disk include the descriptor file name.

Ill-advised ? But when do you think anyone will work directly on the data segments ? Any orchadmin on the .ds file will automatically impact the segment files.

So I do not think it is a bad idea.

Even in oracle, when you truncate a table, all it does is to remove the high-water mark. In Unix, when you delete a file, it only nullifies the inode. Similar is this case.