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.
Kandy
_________________
Try and Try again…You will succeed atlast!!
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?
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.
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?