cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC update in a Idoc to File Scenario

former_member399424
Participant
0 Kudos

Hi Experts,

We have some complex requirement for which we have proposed 3- 4 flows, among them the very first flow is IDOC to File with in which we need to update an Database Table about the mapping status like..

If mapping is successfull then we need to update the field in the DB table as 'Message in Process' else as 'Mapping failed'.

I need help in configuring this flow.

Thanks,

Farooq

Accepted Solutions (1)

Accepted Solutions (1)

Harish
Active Contributor
0 Kudos

Hi Mohammed,

you can use multi mapping for your requirement. multi mapping will contain IDOC to flat and IDOC to JDBC mapping. When first mapping is successful then set the global container variable and populate "Message in Process" in second map else populate "Mapping failed" in second mapping.

regards,

Harish

former_member399424
Participant
0 Kudos

Hi Harsih,

Thanks for your prompt reply..

My question is how do we update the DB table with the status, is it by writing a query inside the UDF or how is it ? and i dont want to have multiple receiver as we already have enough flows 🙂

Regards,

Farooq

Harish
Active Contributor
0 Kudos

Hi Mohammed,

you can use the UDF to update the database or use standard JDBC lookup function (from PI 7.1 onwards).

Please refer the below blog for UDF

For standard JDBC lookup function refer the below blog

regards,

Harish

former_member399424
Participant
0 Kudos

Hi  Harish,

Thanks for your above suggestion, we followed the above method & its was successfull.

Regards,

Mohammed

Answers (0)