Components and format of the row type

As its name implies, the Row group represents a row (or tuple). The Row type is a group with an explicit format. The syntax of that format is based upon the options specified when the tree was created from the Database Interface Designer or the value passed to mtsmaker using the Format mtsmaker command (-X).

see the following table for information about specifying the value for the Row group format list when generating a type tree for a query or table.

Using
Information
Database Interface Designer
Database/query files
mtsmaker
Resource Adapters documentation

There are two different row group formats:

  • delimited row group format
  • fixed row group format

You can specify the syntax for each of these when generating the type tree.