Inserting a whole message using a Tcl UPoC

To insert a whole message without using the whole_message placeholder, you can do this using a Tcl UPoC.

  1. Define an appropriate table schema including all the columns to be used in the SQL statement.
  2. Write a Tcl script to generate a new message that matches the defined Table Schema format based on the original message.
  3. Apply the Tcl script in the pre-outbound TPS.
  4. Write an appropriate SQL statement to do the insert/update.