Skip to main content

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