When using HiRDB data types when a cursor is declared, specify the data types as shown in Table 18-6.
Table 18-6 Description when a cursor is declared, and the acceptance area setting
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 ![]() (1 ![]() ![]() |
HiRDBNVARCHAR | #sql iterator cursor-name(HiRDBNVARCHAR(int n)); | (n![]() (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 ![]() ![]() |