The `<attribute>` Element

The <attribute> element has the following attribute:

Table 1. Attributes of the attribute Element
Attribute Name	Required	Default	Description
`name`	Yes	None	Specifies the name of the column.
`encoding`	No	UTF-8	Specifies the clob data file encoding type.Check Lob Manager.

Note: If the number of attributes defined for a row does not match the number of columns defined the DMX processing will fail.

Note: Also, when processing DMX files, the name of each attribute is not taken into account, the order is taken from the column definition at the start of the file, therefore the ordering of the attributes should match the ordering of the columns.

The attribute element has a required sub-element: value.

The `<value>` Element

The <value> element is the value to be inserted into the column for this row. For a BLOB the value should be a pointer to a file. To be meaningful the name attribute of the attribute element must take its value from one of the column elements' name attributes within the same DMX file. Ordering is also important as when the database is being built, database columns will be updated with content defined by the row elements in the order the column elements are listed within the DMX file.

The <column> elements' type attribute determines the valid attribute values. Table 3, describes the relation between the column type and attribute value.

The <value> element has the following attributes:

Table 2. Attributes of the value Element
Attribute Name	Required	Default	Description
`language`	No	None	The `language` attribute, along with the `country` attribute, make up the locale for an `<attribute>` element.
`country`	No, but if the `language` attribute is specified this attribute must also be specified.	None	The `country` attribute, along with the `language` attribute, make up the locale for an `<attribute>` element.

Important: The primary key/composite key for a record must never be localized within the DMX file for that record. For example, if AddressID is the primary key for the Address table, the AddressID value element within the Address.DMX file must not be localized.

Table 3. Attribute Values
Column Type	Attribute Value
number	Value must be numeric.
text	Value must be text or multi-line text.
bool	Value must be TRUE or FALSE.
id	Value must be numeric.
blob	Value must be a relative path from the DMX file to the blob file.
clob	Value must be a relative path from the DMX file to the clob file.
date	Value must be a valid date or system date. For system date, value must be represented as SYSDATE.
timestamp	Value must be a valid time or system time. For system time, value must be represented as SYSTIME.

The <attribute> Element

The <value> Element

The `<attribute>` Element

The `<value>` Element