This section of the <WriterKeyword>_DEF statement defines the attributes, if any, for a table. A table cannot have both no spatial column and no attributes.
- The <attribute name> specified within FME mapping file must obey the following rules:
- Attribute Names must be in uppercase.
- Attribute Names must obey all length and character restrictions of SpatialWare.
-
The <attribute definition> defines the type and optionality of the attribute, and has the following form:
<attribute type>,(optional|required)
- The supported attribute types are listed in the following table.
|
FME Attribute Type |
C Data Type |
|
smallint |
short integer |
|
integer |
long integer |
|
float |
float |
|
double |
double |
|
char(n) |
unsigned char[n] |
|
date |
struct tm |
The keyword optional or required immediately follows the attribute type and indicates if the attribute is required. If nothing is specified, then the value defaults to optional.
The following example creates a required attribute called NUMOFLANES which is an integer type.
NUMOFLANES integer,required