'Calling db2 function from db connector in IBM Datastage

I would like to create job:

SourceFile -> Transformer -> Lookup connected to DB connector (Lookup Sparse) -> Peek

SourceFile contains dates (string format). In Transformer I've added InputDate with input dates, SourceT and TargetT with some hardcoded parameters. I would like to call

select Function(to_date(Value1, 'YYYY-MM-DD HH:MI:SS'), Value2, Value3) from sysibm.sysdummy1

where values: Value1,2,3 are the transferred from Transformer (Value1=Inputdate, Value2=SourceT and Value3=TargetT ) to DB connector and results of query are transferred to Peek. I can do this using DB2 stored procedure but at this moment it is not possible. I would like to call the function as many times as I have InputDate values in source file.

I tried do this using lookup sparse but still does not work.

Anybody can help me?

datastage


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions