| BYTEINT |
BYTEINT |
| SMALLINT |
SMALLINT |
| INTEGER |
INTEGER |
| BIGINT |
BIGINT |
| REAL |
REAL |
| DECIMAL |
DECIMAL (38,19) |
| VARCHAR |
Depends on input data type:
| Input Data Type |
Output Data Type |
| VARCHAR |
VARCHAR with same CHARLEN, CHARACTER SET, and CASESPECIFIC values as input data type. |
| CHAR |
VARCHAR(32000) with same CHARACTER SET and CASESPECIFIC values as input data type. |
| CLOB |
VARCHAR(32000) with same CHARACTER SET as input data type, NOT CASESPECIFIC |
| Other |
VARCHAR(32000), CHARACTER SET UNICODE, NOT CASESPECIFIC. |
|
| VARCHAR(charlen=len,charset={LATIN | UNICODE},casespecific={YES | NO}) |
VARCHAR(len) with CHARACTER SET charset value, CASESPECIFIC casespecific value. |
| CHAR |
Depends on input data type:
| Input Data Type |
Output Data Type |
| CHAR |
CHAR with same CHARLEN, CHARACTER SET, and CASESPECIFIC values as input data type. |
| VARCHAR |
CHAR(32000) with same CHARACTER SET and CASESPECIFIC values as input data type. |
| CLOB |
CHAR(32000) with same CHARACTER SET as input data type, NOT CASESPECIFIC |
| Other |
CHAR(32000), CHARACTER SET UNICODE, NOT CASESPECIFIC. |
|
| CHAR(charlen=len,charset={LATIN | UNICODE},casespecific={YES | NO}) |
CHAR(len) with CHARACTER SET charset value, CASESPECIFIC casespecific value. |
| DATE |
DATE FORMAT 'YY/MM/DD' |
| TIME |
TIME(6) |
| TIMESTAMP |
TIMESTAMP(6) |
| TIME WITH ZONE |
TIME(6) WITH TIMEZONE |
| TIMESTAMP WITH ZONE |
TIMESTAMP(6) WITH TIMEZONE |
| INTERVAL YEAR |
INTERVAL YEAR(4) |
| INTERVAL MONTH |
INTERVAL MONTH(4) |
| INTERVAL DAY |
INTERVAL DAY(4) |
| INTERVAL HOUR |
INTERVAL HOUR(4) |
| INTERVAL MINUTE |
INTERVAL MINUTE(4) |
| INTERVAL SECOND |
INTERVAL SECOND(4,6) |
| INTERVAL YEAR TO MONTH |
INTERVAL YEAR(4) TO MONTH |
| INTERVAL DAY TO HOUR |
INTERVAL DAY(4) TO HOUR |
| INTERVAL DAY TO MINUTE |
INTERVAL DAY(4) TO MINUTE |
| INTERVAL DAY TO SECOND |
INTERVAL DAY(4) TO SECOND(6) |
| INTERVAL HOUR TO MINUTE |
INTERVAL HOUR(4) TO MINUTE |
| INTERVAL HOUR TO SECOND |
INTERVAL HOUR(4) TO SECOND(6) |
| INTERVAL MINUTE TO SECOND |
INTERVAL MINUTE(4) TO SECOND(6) |
| CLOB |
Depends on input data type:
| Input Data Type |
Output Data Type |
| CLOB |
CLOB with same CHARLEN and CHARACTER SET value as input data type. |
| VARCHAR or CHAR |
CLOB(1048544000) with same CHARACTER SET as input data type. |
| Other |
CLOB(1048544000), CHARACTER SET UNICODE. |
|
| CLOB(charlen=len,charset={LATIN | UNICODE}) |
CLOB(len) with CHARACTER SET charset value. |
| BYTE |
BYTE(32000) |
| BYTE(charlen=len) |
BYTE(len) |
| VARBYTE |
VARBYTE(32000) |
| VARBYTE(charlen=len) |
VARBYTE(len) |
| BLOB |
BLOB(2097088000) |
| BLOB(charlen=len) |
BLOB(len) |
| JSON |
JSON(32000), CHARACTER SET UNICODE. |
| XML |
XML(2097088000) INLINE LENGTH 4046 |