Parameter in Post-SQL

[JDAEMS]

Hi,

is it possible to have a parameter in the POST-SQL?

e.g.: this post sql looks like this:
insert into tblWorker(ID) where NAME = 'Jeff'

Could you make the following out of it:
insert into tblWorker(ID) where NAME = $WorkerName

and then have this defined in the parameter file?

 

[blom0344]

No.
Neither in post or pre. The only place where you can combine parameters is within an SQL override in source qualifier. Look in designer guide in chapter mappings.

Ties Blom