In the above input data, it has one Header and two Detail records but in the real case we may have one Header record and multiple number of Detail records that may be 10 or 1000...
So Messageflow has to insert header record into Header table and Detail records into detail table.
I have tried with this test message:
20021010111aaaaa|||20021009222aaaaabbbbb it is working fine but how can i insert if i have a more than one record to be inserted in the Detail table
ie. 20021010111aaaaa|||20021009222aaaaabbbbb|||20021009333aaaaaccccc can we handle in ESQL dynamically.. If yes how?
It's really urgent for me... i appreciate for any help...
How are you currently separating the test message "20021010111aaaaa|||20021009222aaaaabbbbb" into its corresponding header and detail record and then update the appropriate tables ?
I'm not sure if I understand correctly what you're asking but can't you use the same logic that distinguishes between header and detail records in a message in some kind of looping construct, propagate the header and detail records as individual messages to a filter node. The filter node will then pass the message to the appropriate compute nodes (or insert nodes) to make update to the header table or the detail table.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum