Scalable Database Server, HiRDB Version 8 UAP Development Guide

[Contents][Index][Back][Next]

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 type Description when cursor declared Acceptance 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)

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.