JDBC Type 4 Driver 2.0 Programmer's Reference (SQL/MX 2.x)

For another example, schema is the attribute in the parameter schemaPattern, which is a parameter to the java.sql.ResultSet.getAttributes method.
public ResultSet getAttributes(String catalog,
String schemaPattern,
String typeNamePattern,
String attributeNamePattern)
throws SQLException
If the application passes a null value, the null is treated as follows:
If a parameter name contains the suffix Pattern, the null is interpreted as a % wildcard.
●
If the parameter name does not contain the suffix Pattern, nulls are interpreted as the default value for that parameter.●
Using this example, null parameters are interpreted as follows:
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.