I have a DB function which takes two parameters, one is the count and other is constant string(hard coded value). Count variable is calculated from tAggregateRow component which i can pass it to DB function in tOracleSP component (attached for reference). But how do i pass a constant string value as second parameter. Please suggest!!
As soon as you need it in your schema, you don't have choice, you may change tMap by tJavaRow but it's not really different. You may also use tFilterColumns to add a column by you need something else to populate it.
Thanks for response, i would like to avoid using tMap component just to create a constant string field. Any other way to pass a hard coded string to a procedure/function?
As soon as you need it in your schema, you don't have choice, you may change tMap by tJavaRow but it's not really different. You may also use tFilterColumns to add a column by you need something else to populate it.
