18.3.6 Using data types when a cursor is declared (limited to the native interface version)

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 typeDescription when cursor declaredAcceptance area setting
HiRDBCHAR#sql iterator cursor-name(HiRDBCHAR(int n));n bytes (1 [Figure] n[Figure] 30,000)
HiRDBVARCHAR#sql iterator cursor-name(HiRDBVARCHAR(int n));n bytes (1 [Figure] n[Figure] 32,000)
HiRDBNCHAR#sql iterator cursor-name(HiRDBNCHAR(int n));(n [Figure] 2) bytes (n double-byte characters)
(1 [Figure] n [Figure] 15,000)
HiRDBNVARCHAR#sql iterator cursor-name(HiRDBNVARCHAR(int n));(n[Figure] 2) bytes (n double-byte characters)
(1 [Figure] n [Figure] 16,000)
HiRDBMCHAR#sql iterator cursor-name(HiRDBMCHAR(int n));n bytes (1 [Figure] n [Figure] 30,000)
HiRDBMVARCHAR#sql iterator cursor-name(HiRDBMVARCHAR(int n));n bytes (1 [Figure] n[Figure] 32,000)
HiRDBDECIMAL#sql iterator cursor-name(HiRDBMVARCHAR(int p,int s));Precision p, scale s
(1 [Figure] p[Figure] 29, 0 [Figure] s[Figure] p)
HiRDBBLOB#sql iterator cursor-name(HiRDBBLOB(int n));n bytes
(1 [Figure] n[Figure] 2,147,483,647)
HiRDBBINARY#sql iterator cursor-name(HiRDBBINARY(int n));n bytes
(1 [Figure] n[Figure] 2,147,483,647)