data_type
{ INTEGER | SMALLINT | BIGINT | BYTEINT | DATE |
{ TIME | TIMESTAMP } [ (fractional_seconds_precision) ] [WITH TIME ZONE] |
INTERVAL YEAR [(precision)] [TO MONTH] |
INTERVAL MONTH [(precision)] |
INTERVAL DAY [(precision)] [TO { HOUR | MINUTE | SECOND [(fractional_seconds_precision)] }] |
INTERVAL HOUR [(precision)] [TO { MINUTE | SECOND [(fractional_seconds_precision)] }] |
INTERVAL MINUTE [(precision)] [TO SECOND [(fractional_seconds_precision)]] |
INTERVAL SECOND [(precision) [, fractional_seconds_precision)] |
PERIOD (DATE) |
PERIOD ( { TIME | TIMESTAMP } [(precision)] [WITH TIME ZONE] ) |
REAL |
DOUBLE PRECISION |
FLOAT [ (integer) ] |
NUMBER [ ( { integer | *} [, integer]... ) ] |
{ DECIMAL | NUMERIC } [ ( integer [, integer]... ) ] |
{ CHAR | BYTE | GRAPHIC } [ (integer) ] |
{ VARCHAR | CHAR VARYING | VARBYTE | VARGRAPHIC } [ (integer) ] |
LONG VARCHAR |
LONG VARGRAPHIC |
{ BINARY LARGE OBJECT | BLOB | CHARACTER LARGE OBJECT | CLOB } ( integer [ G | K | M ] ) |
[SYSUDTLIB.] { XML | XMLTYPE } [ ( integer [ G | K | M ] ) ] [ INLINE LENGTH integer ] |
[SYSUDTLIB.] JSON [ ( integer [ K | M ] ) ] [ INLINE LENGTH integer ]
[ CHARACTER SET { UNICODE | LATIN } | STORAGE FORMAT { BSON | UBJSON } ] |
[SYSUDTLIB.] ST_GEOMETRY [ (integer [ K | M ]) ] [ INLINE LENGTH integer ] |
[SYSUDTLIB.] DATASET [ (integer [ K | M ]) ] [ INLINE LENGTH integer ]
STORAGE FORMAT { Avro | CSV [ CHARACTER SET { UNICODE | LATIN } ] }
[ WITH SCHEMA [database.] schema_name ] |
[SYSUDTLIB.] { UDT_name | MBR | ARRAY_name | VARRAY_name }
}
Usage Name
The JSON data type STORAGE FORMAT option can only be specified as:
- An attribute of a table column, since it only specifies a storage format.
- Part of a JSON data type declaration in a CAST statement.
- An optional parameter to the JSON constructor.