Nonstop Database, HiRDB Version 9 UAP Development Guide
To use HiRDB data types with a cursor declared, you must specify the data types as shown in the following table.
Table 19-6 Descriptions and acceptance area settings for using the HiRDB data types when a cursor is declared
Data type | Description when cursor declared | Acceptance area setting |
---|---|---|
HiRDBCHAR | #sql iterator cursor-name(HiRDBCHAR(int n)); | n bytes (1 |
HiRDBVARCHAR | #sql iterator cursor-name(HiRDBVARCHAR(int n)); | n bytes (1 |
HiRDBNCHAR | #sql iterator cursor-name(HiRDBNCHAR(int n)); | (n x 2) bytes (n double-byte characters) (1 |
HiRDBNVARCHAR | #sql iterator cursor-name(HiRDBNVARCHAR(int n)); | (n x 2) bytes (n double-byte characters) (1 |
HiRDBMCHAR | #sql iterator cursor-name(HiRDBMCHAR(int n)); | n bytes (1 |
HiRDBMVARCHAR | #sql iterator cursor-name(HiRDBMVARCHAR(int n)); | n bytes (1 |
HiRDBDECIMAL | #sql iterator cursor-name(HiRDBMVARCHAR(int p,int s)); | Precision p, scale s (1 |
HiRDBBLOB | #sql iterator cursor-name(HiRDBBLOB(int n)); | n bytes (1 |
HiRDBBINARY | #sql iterator cursor-name(HiRDBBINARY(int n)); | n bytes (1 |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.