How is this job called, from a controlling prospective?
The controlling job, whether it be a shell script or a job sequence, you can do this while passing the parameter to this job.
In a shell you can use the commands like date and pass month mask for one and year mask for another. In a sequence job you can use OCONV with the right format for month and year.
Initializing Job parameter with current month and date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 17
- Joined: Fri May 25, 2007 11:59 am
As it is in job level parameter, I cannot initialize it ( It does not support any function) .. Can I do it in before job subroutine shell script ? if so how I'll initialize the parameter in the datastage job.DSguru2B wrote:How is this job called, from a controlling prospective?
The controlling job, whether it be a shell script or a job sequence, you can do this while passing the parameter to this job.
In a shell you can use the commands like date and pass month mask for one and year mask for another. In a sequence job you can use OCONV with the right format for month and year.
Deb,ds_debasis wrote:As it is in job level parameter, I cannot initialize it ( It does not support any function) .. Can I do it in before job subroutine shell script ? if so how I'll initialize the parameter in the datastage job.DSguru2B wrote:How is this job called, from a controlling prospective?
The controlling job, whether it be a shell script or a job sequence, you can do this while passing the parameter to this job.
In a shell you can use the commands like date and pass month mask for one and year mask for another. In a sequence job you can use OCONV with the right format for month and year.
Read DSguru's response again. How are you running your job? Do you have a Job sequence that's calling your job or calling from a shell script or running from Director?
If you are using a controlling job such as a Job Sequence or shell script you can programatically derive current month & date and pass them as parameter values. If you are running manually from the Director then you may have to manually enter as you are doing now.
Hope this helps.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: