This function calculates age from DOB, it returns years, months and partial years (i.e., 17, 3, 17.296272).

Demonstrates the use of conn:execute{} to call a stored procedure.

Create a custom ACK by using a script in an LLP Listener component

This script automatically creates a SQLite database and then generates the tables specified in a VMD.

Demonstrates how to use conn:merge{} with a table that has an auto-incrementing Id column.

How to dehydrate (serialize) raw JSON data, this can be useful for storing in a databases

How to dehydrate (serialize) raw XML data, this can be useful for storing in a databases

How to encode binary files as base 64 text, then embed them as OBX-5 segment repeats

How to correctly escape a SQL query string

How to filter out unwanted HL7 messages (similar principles apply to other message types)

This function formats phone numbers nicely with the area code in brackets.

How to format a report as a single NTE or OBX segment with repeating field or using multiple NTE segments, one for each line of the report

Format specified HL7 message fields in a tab delimited string and push the string to the queue for further processing

How to format an HL7 message without the trailing "|" at the end of each line

Retry an ODBC query to a MySQL DB when an error occurs, can be adapted for retrying LLP etc.

How to insert data from an HL7 message into a database (similar principles apply to other message types)

How to map all or part of an HL7 message (similar principles apply to other message types)

Basic example of merging data into a SQLite database (code is "plug and play" as the DB will be created if it does not exist)

How to normalize X12 delimiters for processing in Iguana scripts, they can be reverted after processing if needed

How to use transactions and conn:begin{}, conn:execute{} and conn:commit{} to insert data into a database in a specific order.