Delimited row group format
If you select Delimited as the value in the Row group format list in either the Generate Type Tree from Tables dialog, the Generate Type Tree from Query dialog, or the Generate Type Tree from Stored Procedures dialog, the Properties window in the generated type tree indicates that the is an explicit group defined as having a delimited syntax.
In the Group options pane, which is located in the dialog for generating the type tree, you can specify the Delimiter, Terminator, and Release setting values to be used in the type tree. The default values are |, None, <CR><LF>, and !, respectively. The Initiator value cannot be specified; it is always set to None.
When using the DBLOOKUP, DBQUERY, GET and PUT map functions with the database adapter, the adapter will use the default values for the Delimiter, Terminator, and Release settings. This is because the data passed to and from the adapter is, in this case, not represented by the type trees generated in the Database Interface Designer. The adapter will use the default values for the Delimiter, Terminator, and Release settings since it cannot access this information from a type tree.
Each component of Row is a type representing a column. These components appear in the component list in the same sequence as they appear in the query or table, as opposed to the type tree, which lists them in alphabetical order. In a delimited Row, each of the columns is defined as optional within the Row by specifying a range of (0:1) for each column component.