how can we add parameters in transformer stage

thumati.praveen · Post by **thumati.praveen** » Tue Feb 05, 2008 9:23 am

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.

ArndW · Post by **ArndW** » Tue Feb 05, 2008 11:44 am

What exactly is the problem? I just tested it and it worked as expected with parameters.

thumati.praveen · Post by **thumati.praveen** » Wed Feb 06, 2008 3:15 am

ArndW wrote:What exactly is the problem? I just tested it and it worked as expected with parameters. ...

Actully i need to pass database connection details as parameter values to transformer stage for getting surrogate key from db2 sequence.

have you checeked? please letme know.

Thanks,
Praveen.

ArndW · Post by **ArndW** » Wed Feb 06, 2008 3:30 am

Have you tried manually entering the parameters, e.g. "#UserId#'?

thumati.praveen · Post by **thumati.praveen** » Wed Feb 06, 2008 3:36 am

ArndW wrote:Have you tried manually entering the parameters, e.g. "#UserId#'? ...

yes, it is not allowing.

ArndW · Post by **ArndW** » Wed Feb 06, 2008 3:56 am

Can you explain? does that mean you cannot type it in, or that you cannot compile or that it won't run correctly?

thumati.praveen · Post by **thumati.praveen** » Wed Feb 06, 2008 4:20 am

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? ...

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.

suppose if you type the user=#userid# password=#pswd#

it is taking direclty #userid# and #pswd# as a values.

ArndW · Post by **ArndW** » Wed Feb 06, 2008 4:25 am

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.

thumati.praveen · Post by **thumati.praveen** » Wed Feb 06, 2008 4:32 am

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.

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.

can we add this fuctionality to transfomer by writing any code?is it possible?

ray.wurlod · Post by **ray.wurlod** » Wed Feb 06, 2008 4:58 am

Why do you need database connection details in a Transformer stage?! This stage type does not connect to databases.

thumati.praveen · Post by **thumati.praveen** » Wed Feb 06, 2008 5:15 am

ray.wurlod wrote:Why do you need database connection details in a Transformer stage?! This stage type does not connect to databases. ...

in v8 we have option to connect the database through transformer stage for getting the surrogate key from database sequences.

ArndW · Post by **ArndW** » Wed Feb 06, 2008 5:16 am

Ray - this is neat new V8 functionality (that ...almost... works)

DSguru2B · Post by **DSguru2B** » Wed Feb 06, 2008 9:25 am

Guys, do the parameter names need to be surrounded with hashes in the transformer stage?

ArndW · Post by **ArndW** » Wed Feb 06, 2008 9:32 am

In those boxes they would have to be, since it expects string values.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 06, 2008 3:12 pm

I always use a state file and Surrogate Key Generator (or SCD) stage. I guess that's why I never spotted it.