Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
825
|
Data Type Name | Raw Type | Length (Range) |
Precision (Range) |
Scale (Range) |
Description |
NUMERIC DATA TYPES | |||||
DECIMAL | NUMERIC | 1 − 10³¹ to 10³¹ − 1. | 15 | 5 | DECIMAL or NUMERIC - Packed decimal number with an implicit decimal point. The position of the decimal point is determined by the precision and the scale of the number. The scale, which is the number of //digits in the fractional part of the number, cannot be negative or greater than the precision. The maximum precision is 31 digits. |
DOUBLE | NUMERIC | -7.2E+75 to 7.2E+75 | X | X | DOUBLE or FLOAT - A double precision floating-point number is a long (64 bits) floating-point number. The range of double precision floating-point numbers is about -7.2E+75 to 7.2E+75 |
FLOAT | NUMERIC | -7.2E+75 to 7.2E+75 | 53 | X | DOUBLE or FLOAT - A double precision floating-point number is a long (64 bits) floating-point number. The range of double precision floating-point numbers is about -7.2E+75 to 7.2E+75 |
INTEGER | NUMERIC | -2147483648 to +2147483647. | X | X | INTEGER - Binary integer with a precision of 31 bits. The range of large integers is -2147483648 to +2147483647 |
NUMERIC | NUMERIC | 1 − 10³¹ to 10³¹ − 1. | 15 | 5 | DECIMAL or NUMERIC - Packed decimal number with an implicit decimal point. The position of the decimal point is determined by the precision and the scale of the number. The scale, which is the number of //digits in the fractional part of the number, cannot be negative or greater than the precision. The maximum precision is 31 digits. |
REAL | NUMERIC | -7.2E+75 to 7.2E+75. | X | X | REAL - A single precision floating-point number is a short (32 bits) floating-point number. The range is about -7.2E+75 to 7.2E+75 |
SMALLINT | NUMERIC | -32768 to +32767. | X | X | SMALLINT - Binary integer with a precision of 15 bits. The range of small integers is -32768 to +32767. |
CHARACTER DATA TYPES | |||||
CHAR | CHARACTER | Between 1 and 255 |
X | X | CHAR - For a fixed-length character string, the length attribute must be between 1 and 255 |
VARCHAR | CHARACTER | 25 | X | X | VARCHAR - For a varying-length character string, the length attribute must between 1 and 32704 |
DATE & TIME DATA TYPES | |||||
DATE | DATE | X | X | X | A date is a three-part value (year, month, and day). Range of year part 0001 to 9999, month part is 1 to 12, the day part is 1 to 28, 29, 30, or 31. Internal representation is a string of 4 bytes. |
TIME | TIME | X | X | X | A time is a three-part value (hour, minute, and second) using a 24-hour clock. Range of the hour part is 0 to 24, minute and second parts is 0 to 59. Internal representation is a string of 3 bytes. |
TIMESTAMP | TIMESTAMP | X | X | X | A timestamp is a seven-part value (year, month, day, hour, minute, second, and microsecond). Internal representation of a timestamp is a string of 10 bytes. The first 4 bytes represent the date, the next 3 bytes the time, and the last 3 bytes the microseconds. |
BINARY & LARGE OBJECT DATA TYPES | |||||
BLOB | BLOB | 1 and 2 147 483 647 | X | X | BLOB is a varying-length string with a maximum length of 2 147 483 647 bytes (2 gigabytes minus 1 byte). |
CLOB | CHARACTER | Between 1 and 2 147 483 647 | X | X | CLOB is a varying-length string with a maximum length of 2 147 483 647 bytes (2 gigabytes minus 1 byte). |
DBCLOB | DBCLOB | 1 and 1 073 741 823 | X | X | DBCLOB is a varying-length string with a maximum length of 1 073 741 823 double-byte characters. |
GRAPHIC | CHARACTER | between 1 and 127 | X | X | GRAPHIC is a sequence of double-byte characters. For a fixed-length graphic string, the length attribute must be between 1 and 127 inclusive. |
ROWID | CHARACTER | X | X | X | Data type to uniquely identifies a row in a table. A ROWID column can be either user-defined or implicitly generated by DB2. The length of a ROWID column as described in the LENGTH column of catalog table SYSCOLUMNS is the internal length, which is 17 bytes. |
VARGRAPHIC | CHARACTER | 1 | X | X | VARGRAPHIC - For a varying-length graphic string, the length attribute must between 1 and 16352. |
XML | XML | X | X | X | Only supported operation is to serialize using XML2CLOB function. Not compatible with any other data type. The only predicate that can be applied to the XML data type is IS NULL or IS NOT NULL |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017