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
824
|
Data Type Name | Raw Type | Length (Range) |
Precision (Range) |
Scale (Range) |
Description |
NUMERIC DATA TYPES | |||||
BIGINT | NUMERIC | -9223372036854775808 to +9223372036854775807 | X | X | |
DECIMAL | NUMERIC | 1 - 10 31 to 1031 - 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 - 1031 to 1031 - 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 | Between 1 and 32704 | X | X | VARCHAR - For a varying-length character string, the length attribute must between 1 and 32704 |
DATE & TIME DATA TYPES | |||||
DATE | DATE | 0001-01-01 to 9999-12-31 | 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 | 00.00.00 to 24.00.00 | 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 | 0001-01-01-00.00.00.000000 to 9999-12-31-24.00.00.000000 | 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 | |||||
BINARY | CHARACTER | Between 1 and 255 | X | X | |
BLOB | BLOB | cannot exceed 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 | 5000 | 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 | cannot exceed 1 073 741 824 | 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 128 | 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. |
VARBINARY | CHARACTER | The maximum length is 32704 | X | X | |
VARGRAPHIC | CHARACTER | Between 1 and 16352 | X | X | VARGRAPHIC - For a varying-length graphic string, the length attribute must between 1 and 16352. |
XML | XML | Limited to 2 GB | 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
DECFLOAT 10-383 to 10+384 or 10-6143 to 10+6144
DECFLOAT 10-383 to 10+384 or 10-6143 to 10+6144