NonStop Server for Java (NSJ) Programmer's Guide (NSJ 2.1+)

Types.TINYINT
No
Types.VARBINARY
No
Types.VARCHAR
Yes
VARCHAR(n)
The JDBC/MX driver maps the following SQL/MP data types to the JDBC data type Types.OTHER:
DATETIME YEAR
DATETIME YEAR TO MONTH
DATETIME YEAR TO DAY
DATETIME YEAR TO HOUR
DATETIME YEAR TO MINUTE
DATETIME MONTH
DATETIME MONTH TO DAY
DATETIME MONTH TO HOUR
DATETIME MONTH TO SECOND
DATETIME DAY
DATETIME DAY TO HOUR
DATETIME DAY TO MINUTE
DATETIME DAY TO SECOND
DATETIME HOUR
DATETIME HOUR TO MINUTE
DATETIME MINUTE
DATETIME MINUTE TO SECOND
DATETIME SECOND
DATETIME FRACTION
INTERVAL YEAR(p)
INTERVAL YEAR(p) TO MONTH
INTERVAL MONTH(p)
INTERVAL DAY(p)
INTERVAL DAY(p) TO HOUR
INTERVAL DAY(p) TO MINUTE
INTERVAL DAY(p) TO SECOND
INTERVAL HOUR(p)
INTERVAL HOUR(p) TO MINUTE
INTERVAL HOUR(p) TO SECOND
INTERVAL MINUTE(p)
INTERVAL MINUTE(p) TO SECOND
INTERVAL SECOND(p)
SQL Escape Clauses
JDBC/MX accepts SQL escape clauses and translates them into equivalent SQL/MX clauses, as shown in the
following table:.
SQL Escape Clause SQL/MX Equivalent Clause
{ d 'date-literal' } DATE 'date-literal'
{ t 'time-literal' } TIME 'time-literal'
{ ts 'timestamp-literal'
}
TIMESTAMP
'timestamp-literal' *