Striim 3.9.7 documentation

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