Inserting a VRL/database schema message into a single column

In the Database Outbound protocol, you can use a VRL as the outbound staging message format. In the dialog box, you can select Variable Length Record (VRL) or Table Schema as the data format.

You can modify the VRL structure after it has been created.

In the Outbound SQL Statement Configurator dialog box, you can select Variable Length Record (VRL) or Table Schema as the data format.

In the Stored Procedure Configurator dialog box, you can select Variable Length Record (VRL) or Table Schema as the data format. The Column list supports VRL field names and database columns.

There are two methods for inserting a VRL/database schema message:

  • Method #1: Enclose the whole message in an escape pair (double-quote). You can write a Tcl script to enclose the whole message in double-quotes to escape the field separator/termination.
  • Method #2: Change the field separator/termination of the Table Schema format used in the Database Outbound protocol to make it different from the one in incoming messages.

    To do this, from the Database Schema Configurator, select Options > Table Schema Options.

    Change the field separator to a different character. For example, you can change it to a semicolon (;). Now, the comma character in the original message is not a field separator anymore. The entire message is parsed as one field and inserted into a single column.