Need to retrieve job file names from a routine

poorna.ds · Post by **poorna.ds** » Wed Feb 04, 2009 4:55 am

I am creating a routine in server jobs which does the auditing of a particular job. It lists the start time, end time, row count etc. Now the problem is I need to get the source file name and target file name that I am passing in the respective source and target stages. I am able to get the stage names but not the files names in it. Can anybody help me out with this problem.

Thanks in advance

**Note: Subject changed to be more descriptive - Content Editor **

mk_ds09 · Post by **mk_ds09** » Wed Feb 04, 2009 6:21 am

If the file names are parameterized then there is one way to find it out by using the dsgetparaminfo !

chulett · Post by **chulett** » Wed Feb 04, 2009 7:20 am

... or just use the parameters in the routine call. However, I'm assuming it's not as simple as that and the file names are hardcoded, yes?

poorna.ds · Post by **poorna.ds** » Wed Feb 04, 2009 7:48 am

chulett wrote:... or just use the parameters in the routine call. However, I'm assuming it's not as simple as that and the file names are hardcoded, yes? ...

That's true. The source file name are hard coded. We thought of parameterizing but that will not be a better approach. Is there any other way we can get the source file names and the target file names?

chulett · Post by **chulett** » Wed Feb 04, 2009 7:57 am

You'll need to query the repository then. Search the forums for CSeqInput or OLETYPE to find several examples of what you'll need to do.