Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 223 / 536

CHAPTER 5 Moving Data In and Out of Databases
203
• 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
22.
•
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.