HPNonStopSQLMPReader data type support and correspondence
SQL/MP type | TQL type |
|---|---|
CHAR(n) | string |
CHAR VARYING(n) | string |
VARCHAR(n) | string |
NATIONAL CHARACTER(n) | string |
NCHAR(n) | string |
NCHAR VARYING(n) | string |
SMALLINT UNSIGNED | int |
SMALLINT SIGNED | short |
INTEGER UNSIGNED | long |
INTEGER SIGNED | int |
LARGEINT | long |
REAL | double |
DOUBLE PRECISION | double |
FLOAT(n) | double |
DATE | DateTime |
TIME | string |
TIMESTAMP | DateTime |
DATETIME YEAR TO x | DateTime |
DATETIME x TO y x ≠ YEAR y = any | string |
INTERVAL | string |
NUMERIC(1-4,0) UNSIGNED | int |
NUMERIC(1-4,0) SIGNED | short |
NUMERIC(5-9,0) UNSIGNED | long |
NUMERIC(5-9,0) SIGNED | int |
NUMERIC(10-18,0) SIGNED | long |
NUMERIC(n,s) UNSIGNED n ≤ 9 s > 0 | string |
NUMERIC(n,s) SIGNED s > 0 | string |
DECIMAL(n,0) UNSIGNED | long |
DECIMAL(n,0) SIGNED | long |
DECIMAL(n,s) UNSIGNED s > 0 | string |
DECIMAL(n,s) SIGNED s > 0 | string |
PIC X(n) | string |
PIC 9(1-4) COMP | int |
PIC S9(1-4) COMP | short |
PIC 9(5-9) COMP | long |
PIC S9(5-9) COMP | int |
PIC S9(10-18) COMP | long |
PIC 9(n)V9(s) COMP | string |
PIC S9(n)V9(s) COMP | string |
PIC 9(n) | long |
PIC S9(n) | long |
PIC 9(n)V9(s) | string |
PIC S9(n)V9(s) | string |