About User Attributes
Readers: For information on the parameters in this dialog that are common to all readers, see:
Writers: For information on the parameters in this dialog that are common to all writers, see:
The following table shows the attribute types that are supported.
For more detailed information, refer to the IBM Netezza Database User’s Guide.
| Name | The name of the field to be written. |
| Type |
This format supports 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:
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. |