Stop updating the dummy response value from RFC lookup to JDBC table

[monikandan_p]

Hi Experts,

   How to stop updating the dummy response value from RFC lookup to JDBC table.

scenerio is File(FTP)->RFCLookup->JDBC

I have passing three input values from file to RFC lookup from that i will get the five response field values and then update to table,For this i can able to procees and updating in table.

Note:when there is no data in ECC system using RFC lookup,From that will get five response values one field called message here i will get the value as dummy,at that time i have to restrict the dummy values not to update in the table.

How to restrict in PI 7.1 any options is there.

Best Regards,

Monikandan.

[former_member184720]

Hi Moni -

Go for enhanced receiver determination and if there is no value then don't process the message to DB.

Else maintain one dummy record in database table and keep on updating the same record whenever your RFC look up returns empty..  (implement a condition on the action attribute to set it to "update")

[monikandan_p]

Hi Hareesh,

       <<<Go for enhanced receiver determination and if there is no value then don't process the message to DB.

        When i choose the enhanced receiver determination by applying the condition i can able to pick the source side file structure  i cant able to pick the RFC lookup structure why becoz ,iam getting the dummy value from lookup only not from file.So i need to restrict from it.

<<<Else maintain one dummy record in database table and keep on updating the same record whenever your RFC look up returns empty..  (implement a condition on the action attribute to set it to "update")

Here i need to insert the each data that iam getting from RFCLookup.In this case how update is possible with one dummy record in table hitting every time the same.Here iam using the action as insert.

Best Regards,

Monikandan.

[former_member184720]

When i choose the enhanced receiver determination by applying the condition i can able to pick the source side file structure  i cant able to pick the RFC lookup structure why becoz ,iam getting the dummy value from lookup only not from file.So i need to restrict from it

>>> You can do that RFC lookup in the receiver determination mapping. So this should not be an issue.

---------------------

Here i need to insert the each data that iam getting from RFCLookup.In this case how update is possible with one dummy record in table hitting every time the same.Here iam using the action as insert.

>>> This is what i suggested. Apply the below mapping on "Action".

If the RFC look up returns dummy then set the action to "update" else "insert" using if then else function.

[Former Member]

Hi Moni

Map the target message type of your JDBC structure with the output of the RFC look up data.

Define the logic in such way that the target message type will only generate if the RFC look up output is not dummy.

In that case the message will fail in PI with mapping error and database will not be updated.