![background image](http://html1.mh-extra.com/html/sybase/adaptive-server-iq-12-4-2/adaptive-server-iq-12-4-2_administration-and-performance-manual_1416503237.webp)
CHAPTER 5 Moving Data In and Out of Databases
217
•
When an arithmetic operation results in a higher scale than the
predetermined scale, Adaptive Server IQ truncates the results to fit the
scale after it has been determined using the rules defined in the Adaptive
Server IQ Reference Manual.
If your results require rounding of the values instead of truncation, you should
use the
ROUND
function in your command. However, for inserts, the
ROUND
function can only be part of its query expression.
The maximum precision for numeric data is 126.
Matching Adaptive Server Enterprise data types
The tables below show which Adaptive Server IQ data types are compatible
with Adaptive Server Enterprise data types.
Here are some general rules:
•
Adaptive Server IQ character string types accept any Adaptive Server
Enterprise character string type.
•
Adaptive Server IQ exact numeric types accept any Adaptive Server
Enterprise number types. However, if the Adaptive Server IQ data type
holds a smaller amount of data than the Adaptive Server Enterprise type,
the value converts to a NULL (for example, when inserting data from the
underlying database into tables).
•
Adaptive Server IQ date/time types accept any Adaptive Server Enterprise
date/time types.
Unsupported Adaptive Server Enterprise data types
These Adaptive Server Enterprise data types are not supported by Adaptive
Server IQ in this version:
•
nchar
•
nvarchar
•
text
•
varbinary
•
image
Summary of Contents for Adaptive Server IQ 12.4.2
Page 1: ...Administration and Performance Guide Adaptive Server IQ 12 4 2 ...
Page 16: ...xvi ...
Page 20: ...Related documents xx ...
Page 40: ...Compatibility with earlier versions 20 ...
Page 118: ...Troubleshooting startup shutdown and connections 98 ...
Page 248: ...Importing data by replication 228 ...
Page 306: ...Integrity rules in the system tables 286 ...
Page 334: ...Cursors in transactions 314 ...
Page 396: ...Users and permissions in the system tables 376 ...
Page 438: ...Determining your data backup and recovery strategy 418 ...
Page 484: ...Network performance 464 ...
Page 500: ...System utilities to monitor CPU use 480 ...
Page 514: ...Characteristics of Open Client and jConnect connections 494 ...
Page 536: ...Index 516 ...