JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

catalog
the default catalog name
schemaPattern
a % wildcard and retrieves data for all schemas of the specified catalog
Type 4 Driver Conformance to SQL Data Types
JDBC Data Types
JDBC Data Types
The following table shows the JDBC data types that are supported by Type 4 driver and their corresponding SQL/MX data types:
JDBC Data Type Support by JDBC Type 4 Driver for NonStop SQL/MX SQL/MX Data Type
Types.Array
No N.A.
Types.BIGINT
Yes LARGEINT
Types.BINARY
Data type is mapped by SQL/MX . Data type varies from that used for table creation. CHAR(n)¹
Types.BIT
Data type is mapped by SQL/MX . Data type varies from that used for table creation. CHAR(1)
Types.BLOB
Yes LARGEINT
Types.CHAR
Yes CHAR(n)
Types.CLOB
Yes LARGEINT
Types.DATE
Yes DATE
Types.DECIMAL
Yes DECIMAL(p,s)
Types.DISTINCT
No N.A.
Types.DOUBLE
Yes DOUBLE PRECISION
Types.FLOAT
Yes FLOAT(p)
Types.INTEGER
Yes INTEGER
Types.JAVA_OBJECT
No N.A.
Types.LONGVARBINARY
Data type is mapped by SQL/MX . Data type varies from that used for table creation. VARCHAR(n)¹
Types.LONGVARCHAR
Yes
Maximum length is 4018
VARCHAR[(n)]
Types.NULL
No N.A.
Types.NUMERIC
Yes NUMERIC(p,s)
Types.REAL
Yes FLOAT(p)
Types.REF
No N.A.
Types.SMALLINT
Yes SMALLINT
Types.STRUCT
No N.A.
Types.TIME
Yes TIME
Types.TIMESTAMP
Yes TIMESTAMP
Types.TINYINT
Data type is mapped by SQL/MX . Data type varies from that used for table creation. SMALLINT
Types.VARBINARY
Data type is mapped by SQL/MX . Data type varies from that used for table creation. VARCHAR(n)¹