DSXchange

Hi,

I have to schedule a job which would run on 2nd of every month. It would take last month's file as input. For example suppose this is being run on 2nd Aug, so it would use the input file of Jul. File have extension as yyyymm eg: abc201007. How can I pass a parameter whose values would dynamically change every month?

Using Date function, you can know current date. From there, you can extract what you want and form a string (yyyymm) and then pass it as a parameter. This can be completely automated to run every month.

kandyshandy wrote:Using Date function, you can know current date. From there, you can extract what you want and form a string (yyyymm) and then pass it as a parameter. This can be completely automated to run every month.

File name is input parameter as in say input file for a transformaer stage. I can get this yyyymm value in a transformer in stage variable but how do I asign it to input file name?

Can you please help em a bit more on this?

IS there any way except unix scripting?

Can I use user activity stage to create a variable who would have value abc201007
so basialy I want to do abc:transforms to append 201007.

Is it doable? if yes, how exactly?

Use variable acvity and apply functions like iconv, Oconv then you easily get it through. if you need full information on iconv and oconv then refer the documentation. it clearly explained.

Thanks
Ravi

mailravi.dw@gmail.com wrote:Use variable acvity and apply functions like iconv, Oconv then you easily get it through. if you need full information on iconv and oconv then refer the documentation. it clearly explained.

Thanks
Ravi

Can we use iconv and oconv functions in parallel stage?

You can call IConv and OConv functions only from BASIC Transformer stage in the parallel job.

anbu wrote:You can call IConv and OConv functions only from BASIC Transformer stage in the parallel job.

So it means I can't use these in user activity stage. How can I get it then?

Sequence job is a server job. You can call IConv and OConv functions from User Variable activity

anbu wrote:Sequence job is a server job. You can call IConv and OConv functions from User Variable activity

is it

can i call parallel job using sequence then?

Yes