Parameterized values getting hard coded
Moderators: chulett, rschirm, roy
Parameterized values getting hard coded
Hi,
I'm facing a strange issue with the parametrization of values in DB2/Teradata Connector stages.
All the DB related parameters - DBname, DBSchema, DBpassword are passed to the Db2/Teradata Connector stage using a parameter set. Still, when I compile and migrate the job from one environment to other (Development to QC), somehow, these database parameters become hard coded.
Am I missing any patches or something??
Please advise.
Thanks
I'm facing a strange issue with the parametrization of values in DB2/Teradata Connector stages.
All the DB related parameters - DBname, DBSchema, DBpassword are passed to the Db2/Teradata Connector stage using a parameter set. Still, when I compile and migrate the job from one environment to other (Development to QC), somehow, these database parameters become hard coded.
Am I missing any patches or something??
Please advise.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes Ray, parameter set migration was done. Let me repeat, the problem is occurring sometimes, it is not occurring for all the jobs. Had the parameter set not been migrated, all the jobs would have given this problem.
And I see this problem only for Connector stages - both DB2 & Teradata. The enterprise stages never gave this kind of problem.
And I see this problem only for Connector stages - both DB2 & Teradata. The enterprise stages never gave this kind of problem.
Iknow this thread is from quite some time ago, but we are experiencing the same issues with DB2 Connector stage in DS 8.5. It is intermittent but may be related to viewing the data. It isn't always reproducible and the only way to catch it prior to migrating from one environment to the next seems to be searching the DSX file for hard coded values.
Does anyone else experience this and/or know of a patch from IBM?
Does anyone else experience this and/or know of a patch from IBM?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Lose the dollar sign. Use #ParamSet.Param1# rather than #ParamSet.$Param1# unless $Param1 exists as an environment variable parameter within the parameter set ParamSet.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I'm seeing intermittent problems like this in 8.7 as well. Jobs are being migrated with object code to production, and in some cases are still trying to run with DEV settings, even though environment variables are set correctly.
Recompilation resolves the issue and we can't see a pattern in the failures.
Recompilation resolves the issue and we can't see a pattern in the failures.
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am