FairCom RTG COBOL Edition User's Guide

<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.

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.