Sybase 12.4.2 User Manual

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 
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.