Using varibles in target structure + JDBClookup produce NULLs

[former_member187587]

Hi,

We are running SAP PI 7.1 SP5.

I am using the new functionality of Variables in target mapping and

also JDBCLookups.

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.

did any oen experianced issue regarding Variables in target as inputs for UDF or lookup?

this failes also in simple concat standard function.

your share experiance will me most appriciated.

Nimrod.g

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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.

[Former Member]

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

[Former Member]

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