Nonstop Database, HiRDB Version 9 UAP Development Guide
The table below shows the correspondence between the HiRDB data types and the SQLJ data types. To use embedded variables in SQLJ, declare variables according to this table.
Table 19-4 Correspondence between HiRDB data types and SQLJ data types
HiRDB data types | SQLJ data types (Java data types) | |
---|---|---|
When a null value is included | When a null value is not included | |
CHAR#1 | java.lang.String | N/A |
JP.co.Hitachi.soft.HiRDB.pdjpp.runtime.HiRDBCHAR#4 | N/A | |
VARCHAR | java.lang.String | N/A |
JP.co.Hitachi.soft.HiRDB.pdjpp.runtime.HiRDBVARCHAR#4 | N/A | |
NCHAR#1 | java.lang.String | N/A |
JP.co.Hitachi.soft.HiRDB.pdjpp.runtime.HiRDBNCHAR#4 | N/A | |
NVARCHAR#1 | java.lang.String | N/A |
JP.co.Hitachi.soft.HiRDB.pdjpp.runtime.HiRDBNVARCHAR#4 | N/A | |
MCHAR#1 | java.lang.String | N/A |
JP.co.Hitachi.soft.HiRDB.pdjpp.runtime.HiRDBMCHAR#4 | N/A | |
MVARCHAR#1 | java.lang.String | N/A |
JP.co.Hitachi.soft.HiRDB.pdjpp.runtime.HiRDBMVARCHAR#4 | N/A | |
DECIMAL#2 | java.math.BigDecimal | N/A |
JP.co.Hitachi.soft.HiRDB.pdjpp.runtime.HiRDBDECIMAL#4 | N/A | |
SMALLINT | java.lang.Short | short |
INTEGER | java.lang.Integer | int |
REAL, SMALLFLT | java.lang.Float | float |
FLOAT, DOUBLE PRECISION | java.lang.Double | double |
DATE | java.sql.Date | N/A |
TIME | java.sql.Time | N/A |
TIMESTAMP | java.sql.Timestamp | N/A |
INTERVAL HOUR TO SECOND | N/A | N/A |
INTERVAL YEAR TO DAY | N/A | N/A |
BLOB#3 | JP.co.Hitachi.soft.HiRDB.pdjpp.runtime.HiRDBBLOB#4 | byte[] |
BINARY | JP.co.Hitachi.soft.HiRDB.pdjpp.runtime.HiRDBBINARY#4 | byte[] |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.