The following table documents the valid targets for fromsql functionality.
| Source Input | Source Data Type of Routine Definition | Target Data Type of Routine Definition | Target Output |
|---|---|---|---|
| UDT | UDT | BYTEINT | BYTEINT
SMALLINT INTEGER BIGINT DECIMAL NUMERIC REAL FLOAT DOUBLE PRECISION CHARACTER VARCHAR DATE |
| SMALLINT | |||
| INTEGER | |||
| BIGINT | |||
| DECIMAL NUMERIC |
|||
| REAL FLOAT DOUBLE PRECISION |
|||
| BYTE | BYTE
VARBYTE BLOB |
||
| VARBYTE | |||
| BLOB | |||
| CHARACTER | CHARACTER
VARCHAR C LOB BYTEINT SMALLINT INTEGER BIGINT DECIMAL NUMERIC REAL FLOAT DOUBLE PRECISION DATE TIME TIME WITH TIME ZONE TIMESTAMP TIMESTAMP WITH TIME ZONE |
||
| VARCHAR CHARACTER VARYING |
|||
| CLOB | CLOB
CHARACTER VARCHAR |
||
| DATE | DATE BYTEINT SMALLINT INTEGER BIGINT DECIMAL NUMERIC REAL FLOAT DOUBLE PRECISION CHARACTER VARCHAR |
||
| TIME | TIME
TIME WITH TIME ZONE |
||
| TIME WITH TIME ZONE | |||
| TIMESTAMP | TIMESTAMP
TIMESTAMP WITH TIME ZONE |
||
| TIMESTAMP WITH TIME ZONE | |||
| INTERVAL YEAR | INTERVAL YEAR INTERVAL YEAR TO MONTH INTERVAL MONTH |
||
| INTERVAL YEAR TO MONTH | |||
| INTERVAL MONTH | |||
| INTERVAL DAY | INTERVAL DAY INTERVAL DAY TO HOUR INTERVAL DAY TO MINUTE INTERVAL DAY TO SECOND INTERVAL HOUR INTERVAL HOUR TO MINUTE INTERVAL HOUR TO SECOND INTERVAL MINUTE INTERVAL MINUTE TO SECOND INTERVAL SECOND |
||
| INTERVAL DAY TO HOUR | |||
| INTERVAL DAY TO MINUTE | |||
| INTERVAL DAY TO SECOND | |||
| INTERVAL HOUR | |||
| INTERVAL HOUR TO MINUTE | |||
| INTERVAL HOUR TO SECOND | |||
| INTERVAL MINUTE | |||
| INTERVAL MINUTE TO SECOND | |||
| INTERVAL SECOND |