Name |
The name of the field to be written. |
Type |
Choose one of the following field types.
bigint
Integer field containing 64-bit values in the range -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
Field size: 8 bytes
byteint
Integer field containing 8-bit values in the range -128 to 127.
Field size: 1 byte
smallint
Integer field containing 16-bit values in the range -32,768 to 32,767.
Field size: 2 bytes
integer
Integer field containing 32-bit values in the range -2,147,483,648 to 2,147,483,647.
Field size: 4 bytes
boolean
Logical field that stores true or false. The following values are acceptable:
- true or false, or any string that begins with t or f
- any non-zero numeric (maps to true) or 0 (maps to false),
- yes or no, or any string that begins with y or n.
On read, a Boolean value is converted in FME to a Boolean Yes or No for true and false, respectively.
real
Floating point number with a precision of 6.
Field size: 4 bytes
double
Floating point number with a precision of 15.
Field size: 8 bytes
numeric(width,decimal)
Numeric field with an overall precision of width (number of significant digits) and scale of decimal (number of digits after the decimal point).
width can range from 1 to 38; decimal can range from 0 to width.
Field size: Ranges from 4 bytes to 16 bytes depending on the field width.
date
Temporal (date) field composed of year, month, and day; ranging from January 1, 0001, to December 31, 9999.
Field size: 4 bytes
time
Temporal (time) field composed of hours, minutes, and seconds accurate to six decimal places (microseconds), ranging from 00:00:00.000000 to 23:59:59.999999.
Field size: 8 bytes
timetz
Temporal (time) field composed of hours, minutes, seconds accurate to six decimal places (microseconds), and time zone offset from GMT. Values range from 00:00:00.000000+13:00 to 23:59:59.999999-12:59.
Field size: 12 bytes
timestamp
Temporal (date/time) field composed of a date part and a time part, ranging from January 1, 0001 00:00:00.000000 to December 31, 9999 23:59:59.999999.
Field size: 8 bytes
char(width)
Character field for storing fixed-length strings.
The width parameter controls the maximum number of characters that can be stored in the field. When a character field is written, it is right-padded with space characters, or truncated to fit the width.
When a character value is retrieved, any right-padded space characters are stripped away.
Each character is stored in a single byte; the field size will be width bytes in size. The maximum width of this field is 64000 bytes.
varchar(width)
This is similar to the char field type, except it writes variable length strings.
Strings that are shorter than width characters will not be padded with space characters, while strings that are longer than width will be truncated.
nchar(width)
Character field for storing fixed-length Unicode strings.
The width parameter controls the maximum number of characters that can be stored in the field. When a character field is written, it is right-padded with space characters or truncated to fit the width.
When a character value is retrieved, any right-padded space characters are stripped away.
Note that Unicode strings are stored using UTF-8 encoding, therefore each character may require anywhere from 1-4 bytes for storage. The maximum width of this field is 16000 characters, for a maximum of 64000 bytes.
nvarchar(width)
This is similar to the nchar field type except it writes variable-length strings.
Strings that are shorter than width characters will not be padded with space characters, while strings which are longer than width bytes will be truncated.
varbinary(width)
This is similar to the varchar field type except that it stores raw binary data. Up to width bytes can be stored in a varbinary field.
Netezza NPS versions 7 and above support varbinary fields.
|