SAP Sybase ASE Writer: User Attributes
For information on the parameters in this dialog that are common to all readers, see:
For information on the parameters in this dialog that are common to all writers, see:
User attributes for this format are defined below.
Name | The name of the field to be written. |
Type |
This section describes the attribute types for a table. bigdatetime
This type is used to represent date and time data from January 1, 0001 to December 31, 9999 with microsecond precision. bigint
This type is used to represent 64-bit signed integers. bigtime
This type is used to represent time data with microsecond precision. binary
This type is used to represent fixed length binary data up to a length of 255 bytes. bit
This type is used to represent the logical values true and false. Bit columns cannot be null and cannot have indexes specified. char
This type is used to represent fixed length character data. date
This type is used to represent date data from January 1, 0001 to December 31, 9999. datetime
This type is used to represent date and time data from January 1, 1753 to December 31, 9999 with up to 1/300 second precision. decimal
This type is used to represent numeric data with a precision and scale of up to 38 digits. double
This type is used to represent 64-bit floating precision numeric data. image
This type is used to represent binary data up to a length of 2^31-1 bytes. int
This type is used to represent 32-bit signed integers. money
This type is used to represent monetary values between -922,337,203,685,477.5808 and 922,337,203,685,477.5807. nchar
This type is used to represent fixed length multibyte character data. numeric
This type is used to represent numeric data with a precision and scale of up to 38 digits. The decimal and numeric types are identical with the exception that a numeric column with a scale of 0 can be specified as an IDENTITY column. nvarchar
This type is used to represent variable length multibyte character data. real
This type is used to represent 32-bit floating precision numeric data. smalldatetime
This type is used to represent date and time data from January 1, 1900 to June 6, 2079 with minute precision. smallint
This type is used to represent 16-bit signed integers. smallmoney
This type is used to represent monetary values between -214,748.3648 and 214,748.3647. text
This type is used to represent character data up to a length of 2,147,483,647 bytes. time
This type is used to represent time data with millisecond precision. tinyint
This type is used to represent integers between 0 and 255. unichar
This type is used to represent fixed length Unicode character data. univarchar
This type is used to represent variable length Unicode character data. unsigned bigint
This type is used to represent 64-bit unsigned integers. unsigned int
This type is used to represent 32-bit unsigned integers. unsigned smallint
This type is used to represent 16-bit unsigned integers. varbinary
This type is used to represent variable length binary data up to a length of 255 bytes. varchar
This type is used to represent variable length character data. |
Index |
The types of indexes and constraints to create for the column, if the table is created. Each index and constraint contains only one column. The valid values for the column type are listed below: PrimaryKey: This type specifies that the column is a primary key for the table. Only one primary key is allowed per table. Unique: This type specifies that the column has a UNIQUE constraint. NotNull: A non-nullable constraint. Null: A nullable constraint. |