Product Documentation

FairCom RTG COBOL User Guide

Previous Topic

Next Topic

<schema> table element

The schema describes a schema belonging to the data file; more schemas can be defined if the table contains more than one record schema. If multiple schemas are defined, a <filters> declaration is required.

Elements

Element

Description

<field>

Describes one of the fields comprising the current schema.

Mandatory Attributes

Attribute

Description

name

The name to assign to the current schema. This name will map a SQL table containing all the records selected by this schema.

Optional Attributes

Attribute

Description

filter

Specifies which filter to use to generate the current schema, use one of the filter numbers defined in the <filters> element

size

The record length for the current schema specified in number of bytes.

onConvertError

Specifies the default action to take when a value cannot be converted into SQL readable data.

If "error" is specified an error will be returned and the selected table records will not be shown unless the field content matches the bindefault or cbdefault (see <field> schema element) in which case the value will be replaced with a SQL null value.

If "null" is specified, the values that cannot be converted will be replaced with SQL null values.

If "strict" is specified, an error will be returned and the selected table records will not be shown.

TOCIndex