how can we add parameters in transformer stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
how can we add parameters in transformer stage
Hi,
I am facing one problem with tranformer surrogate key tab.
if any body did the Parameters in surrogate key tab for database sequnce type please assest me the same.
Thanks,
Praveen.
I am facing one problem with tranformer surrogate key tab.
if any body did the Parameters in surrogate key tab for database sequnce type please assest me the same.
Thanks,
Praveen.
What exactly is the problem? I just tested it and it worked as expected with parameters.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
Have you tried manually entering the parameters, e.g. "#UserId#'?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
Can you explain? does that mean you cannot type it in, or that you cannot compile or that it won't run correctly?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
It is allowing to type the parameters but you know tha job is aborting because the database values are taking what you are typed in the text boxes.ArndW wrote:Can you explain? does that mean you cannot type it in, or that you cannot compile or that it won't run correctly? ...
suppose if you type the user=#userid# password=#pswd#
it is taking direclty #userid# and #pswd# as a values.
In that case I think you have discovered a limitation; it is unclear from the documentation as to whether or not this is a bug (which means that it probably isn't a bug according to IBM). I would guess that the only workaround is to hard-code the values and create an appropriate DB2 userid with access rights limited to just this sequence.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
you know it is very dificult if the database will change again I need to open my all jobs i need to edit the transformer for testing and production.ArndW wrote:In that case I think you have discovered a limitation; it is unclear from the documentation as to whether or not this is a bug (which means that it probably isn't a bug according to IBM). I would guess that the only workaround is to hard-code the values and create an appropriate DB2 userid with access rights limited to just this sequence.
can we add this fuctionality to transfomer by writing any code?is it possible?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 106
- Joined: Wed Oct 04, 2006 5:21 am
Ray - this is neat new V8 functionality (that ...almost... works)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
In those boxes they would have to be, since it expects string values.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: