INSERT…LOCATION supports additional ASE data types [CR 442348]

12.7 ESD #2 supports inserting data from an Adaptive Server Enterprise database column of data type UNSIGNED SMALLINT, NCHAR, NVARCHAR, DATE, or TIME using the INSERT...LOCATION syntax of the INSERT statement.

The Adaptive Server Enterprise data type UNSIGNED SMALLINT is not supported by Sybase IQ INSERT...LOCATION on Linux 32-bit systems, but is supported by INSERT...LOCATION on all other Sybase IQ supported platforms.

The following additions document the support of these ASE data types with INSERT...LOCATION.

In Chapter 7, “Moving Data In and Out of Databases,” the third bullet under “Note the following” in the section “Unsupported Adaptive Server Enterprise data types” should now say:

Sybase IQ does not support the Adaptive Server Enterprise data types TEXT or unsigned smallint, but you can insert data from an ASE database column of data type TEXT or unsigned smallint using the LOCATION syntax of the INSERT statement.

Add the following row to Table 7-14: Integer data types in Chapter 7, “Moving Data In and Out of Databases.”

Adaptive Server Enterprise data type	Sybase IQ data type	Notes
unsigned smallint	Not supported	Sybase IQ does not support the Adaptive Server Enterprise data type unsigned smallint, but you can insert data from an ASE database column of data type unsigned smallint using INSERT...LOCATION.

Add the following row to Table 7-16: Character data types in Chapter 7, “Moving Data In and Out of Databases.”

Adaptive Server Enterprise data type	Sybase IQ data type	Notes
nchar	Not supported	Sybase IQ does not support the Adaptive Server Enterprise data type nchar, but you can insert data from an ASE database column of data type nchar using INSERT...LOCATION to character type columns.
nvarchar	Not supported	Sybase IQ does not support the Adaptive Server Enterprise data type nvarchar, but you can insert data from an ASE database column of data type nvarchar using INSERT...LOCATION to character type columns.

Add the following rows to Table 7-18: DATE/TIME data types in Chapter 7, “Moving Data In and Out of Databases.”

Adaptive Server Enterprise data type	Sybase IQ data type	Notes
date	date	You can insert data from an ASE database column of data type date using INSERT...LOCATION.
time	time	The Sybase IQ data type is the Time of day, containing hour, minute, second, and fraction of a second. The fraction is stored to 6 decimal places. A time value requires 8 bytes of storage. The Adaptive Server Enterprise data type time is between 00:00:00:000 and 23:59:59:999. You can use either military time or 12AM for noon and 12PM for midnight. A time value must contain either a colon or the AM or PM signifier. AM or PM may be in either uppercase or lowercase. A time value requires 4 bytes of storage. You can insert data from an ASE database column of data type time using INSERT...LOCATION.

Adaptive Server Enterprise data type

Sybase IQ data type

Notes

date

You can insert data from an ASE database column of data type date using INSERT...LOCATION.

time

The Sybase IQ data type is the Time of day, containing hour, minute, second, and fraction of a second. The fraction is stored to 6 decimal places. A time value requires 8 bytes of storage.

The Adaptive Server Enterprise data type time is between 00:00:00:000 and 23:59:59:999. You can use either military time or 12AM for noon and 12PM for midnight. A time value must contain either a colon or the AM or PM signifier. AM or PM may be in either uppercase or lowercase. A time value requires 4 bytes of storage.

You can insert data from an ASE database column of data type time using INSERT...LOCATION.