Sybase 12.4.2 manual 203

CHAPTER 5 Moving Data In and Out of Databases

•When you insert data selected from another database

•When you load data from a flat file

When an explicit conversion is needed, the way that you specify the conversion depends on whether you are loading from a flat file or inserting selected rows:

•In the LOAD TABLE statement, you convert data explicitly by specifying a format in the column-spec.

•In the INSERT statement, you convert data explicitly using the data conversion functions CAST, CONVERT, and DATEPART in the SELECT statement.

For information on implicit and explicit conversions between Adaptive Server IQ data types, see Table 5–6 .

For information on conversions that occur if you are inserting from proxy tables, see the Adaptive Server IQ Installation and Configuration Guide for Windows NT.

While most Adaptive Server IQ data types are fully compatible with Adaptive Server Anywhere and Adaptive Server Enterprise data types of the same name, there are some differences. For details on compatibility, see “Matching Adaptive Server Anywhere data types” and “ “Matching Adaptive Server Enterprise data types.”

For compatibility among versions, a few data types have been defined as synonyms of other data types:

•DECIMAL is a synonym for NUMERIC.

•INTEGER is a synonym for INT.

•DATETIME is a synonym for TIMESTAMP.

•FLOAT (precision) is a synonym for REAL or DOUBLE, depending on the

value of precision. For Adaptive Server Enterprise, REAL is used for precision less than or equal to 15, and DOUBLE for precision greater than

15.For Adaptive Server IQ and Adaptive Server Anywhere, the cutoff is platform-dependent, but on all platforms the cutoff value is greater than

•MONEY is an Adaptive Server Enterprise-compatible synonym for NUMERIC(19,4), allowing NULL.

•SMALLMONEY is an Adaptive Server Enterprise-compatible synonym for NUMERIC(10,4), allowing NULL.

203