Nonstop Database, HiRDB Version 9 UAP Development Guide

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

19.3.6 Using data types when a cursor is declared (limited to the native interface edition)

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 [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 x 2) bytes (n double-byte characters)
(1 [Figure] n [Figure] 15,000)
HiRDBNVARCHAR #sql iterator cursor-name(HiRDBNVARCHAR(int n)); (n x 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) 2011, Hitachi, Ltd.