The <attribute> element has the following attribute:
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. |
The attribute element has a required sub-element: value.
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:
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. |
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. |