Multiple keyed lists
This is a sample return value that uses a complex mapping between parsed message data and multiple tables.
{
{TEMPLATE msginsert}
{NAMELIST {TABLENAME MID MSGDATA}}
{TYPELIST {SQL_CHAR SQL_CHAR SQL_CHAR}}
{VALUELIST {MessageData 0.0.152 {xxxxxxxxxxxxxxxxxxxxxxx}}}
}
{
{TEMPLATE patientinsert}
{NAMELIST {TABLENAME PATIENTID …}}
{TYPELIST {SQL_CHAR SQL_CHAR …}}
{VALUELIST {PatientInfo 321 …}}
}
If there are multiple tables, then the inserts are run in the list order.