hi Nimrod,
I am on PI 7.1 SP5 too. I just tried variable with following:
1) create variable testField in target structure
2) map source field sourceFielda concatenating constant "abc" to testField
3) map source field sourceFieldb concatenating testField to target field targetFieldb.
This mapping is working corrrectly, no NULL problem as yours occured in my test.
Jayson
I continued with UDF:
map targetFieldc from testField using UDF testUDF while it returns value of testField concatenating a constant "returned from UDF".
Run the test, targetFieldc got the expected value, no NULL problem.
>>I have found out that while using this variables as the input
parameters for a JDBC Lookup (from the "Conversion" functions or from a
UDF) the values appear to be NULLs or unrecognized on the Database
level.
It means that the variable you assigned to target is not populated at runtime..first store some value in variable and then test it....
Thanks
Farooq
Hi NImrod
Check for the values you passed to UDF or JDBC lookup. Are they available at runtime then only you can receiver output.
Thanks
Gaurav
