DSXchange

Hi all,

I'm using the DSJobReport in after job routine to get all the job details. Now here the DataStage names the report file by itself as JobName_YYYYMMDD_HHMMSS.txt. Is there a way for me to give the report a name of my choice?

Any help is greatly appreciated.

Thanks.

No, but you can rename the report immediately it has been created.

Hi Ray,

Are you saying that I can rename the file within the after job routine command prompt or manually later?

Thanks

Within the after-job subroutine if you wish. The file is closed before this is executed.

Please forgive my ignorance but..... How do I do that?

hi,

There could be couple of ways to achieving it.

1. AfterJobsubroutine - go to your -->JOb properties--> under general tab you will find Afterjobsubroutine give your rename command in Input value.

2. if DS is installed in unix , and you are using unix script to call your jobs , after your job finish you can give rename command in your unix script.

Use the supplied after-job subroutine ExecSH to execute your mv command.

@ray.wurlod

We are using DSJobReport in after job routine to get Job Report Details.
How can we use both DSJobReport and ExecSH for a single Job. Please correct me if I am wrong?

Wrap them in your own after-job subroutine (using CALL statements). You can use DSExecute rather than ExecSH within your own routine.