HPNonStopSQLMXReader data type support and correspondence
SQL/MX type | TQL type |
---|---|
PIC X(n) | string |
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 |
NUMBER(1-4,0) UNSIGNED | int |
NUMBER(1-4,0) SIGNED | short |
NUMBER(5-9,0) UNSIGNED | long |
NUMBER(5-9,0) SIGNED | int |
NUMBER(10-128,0) UNSIGNED | string |
NUMBER(10-18,0) SIGNED | long |
NUMBER(19-128,0) SIGNED | string |
NUMBER(1-9,s) UNSIGNED s > 0 | string |
NUMBER(10-128,s) UNSIGNED | string |
NUMBER(1-18,s) SIGNED s > 0 | string |
NUMBER(19-128,s) SIGNED | 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-128,0) UNSIGNED | string |
NUMERIC(10-18,0) SIGNED | long |
NUMERIC(19-128,0) SIGNED | string |
NUMERIC(1-9,s) UNSIGNED s > 0 | string |
NUMERIC(10-128,s) UNSIGNED | string |
NUMERIC(1-18,s) SIGNED s > 0 | string |
NUMERIC(19-128,s) SIGNED | 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 |
REAL | float |
DOUBLE PRECISION | double |
FLOAT(n) | double |
DATE | DateTime |
TIME(n) | string |
TIMESTAMP(n) | DateTime |
INTERVAL | 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 |