Creating tables for GSAM databases

A single table can be defined to a GSAM database with the CREATE TABLE statement.

The table is optional and will be treated as a virtual table. The columns contained within the table will be non-searchable by IMS but are used by the universal drivers to map the contents of the record.

The only table option allowed on the CREATE TABLE statement are:
  • IN DATABASE
  • CCSID
  • column definitions
  • map definitions

The columns must be non-searchable and defined without an INTERNALNAME or PRIMARY KEY.