Hi All,
In my project there are so many jobs with job parameter REPORT_DATE. These jobs are in production for long time.
Now with the export this project I have created new project and started compiling jobs. Some of the jobs with this parameter are not compiling, throughing following error message,
Error preprocessing Transform Derivation for stage CFlyCtDeltaload.XTERM.
Link DSLink52, Column REPORT_DATE: Oconv(Iconv(ReportDate,'D-MDY[2,2,4]'),'D-MDY[2,2,4]')
Expected: left parenthesis ("(")
When I correct the name with Rdate job is working fine. But I cant actually change like this since this programs are in production.
Some more information
Both are same environment and same version of DataStage and UNIX not change.
Please advice.
Prakash
Issue with variable
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
Actually this is a sequencer and ReportDate is the sequencer parameter and this param is being assigned to the job which sequencer is calling and in the job the param name ins REPORT_DATE.
Also this is jobs are already running in production for years and never had this problem.
Just when I am importing and compiling this jobs in new development project I am getting this compilation error.
Yet in production this jobs are still running with out any changes.
Also this is jobs are already running in production for years and never had this problem.
Just when I am importing and compiling this jobs in new development project I am getting this compilation error.
Yet in production this jobs are still running with out any changes.
Last edited by srinivas.g on Fri Sep 04, 2009 5:16 am, edited 1 time in total.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Re: Issue with variable
What is this 'correction' that you need to do?srinivas.g wrote:When I correct the name with Rdate job is working fine. But I cant actually change like this since this programs are in production.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am