Nonstop Database, HiRDB Version 9 UAP Development Guide
The table below lists the data types that are set in the Value property of the HiRDBParameter class, for example, during execution of the INSERT and GetXXXX methods of the HiRDBDataReader class that are used during execution of SELECT. Note that HiRDB's NULL is represented by DBNull.Value of the .NET Framework type.
Table 16-5 Data types and accessories for HiRDB-type UAPs
Classification | HiRDB data type | .NET Framework type used by UAPs, for example in INSERT | Accessory used by UAP for SELECT |
---|---|---|---|
Character | CHAR[ACTER] | String | GetString() |
VARCHAR/CHAR[ACTER]VARYING | String | GetString() | |
NCHAR/NATIONAL CHAR[ACTER] | String | GetString() | |
NVARCHAR/NCHAR VARYING | String | GetString() | |
MCHAR | String | GetString() | |
MVARCHAR | String | GetString() | |
Numeric value | [LARGE]DEC[IMAL]/NUMERIC | Decimal | GetDecimal() |
SMALLINT | Int16 | GetInt16() | |
INT[EGER] | Int32 | GetInt32() | |
SMALLFLT/REAL | Single | GetFloat() | |
FLOAT/DOUBLE PRECISION | Double | GetDouble() | |
Date and time | DATE | DateTime | GetDateTime() |
TIME | DateTime | GetDateTime() | |
TIMESTAMP | DateTime | GetDateTime() | |
Other | BINARY | Byte[] | GetBytes() |
BLOB | Byte[] | GetBytes() | |
INTERVAL YEAR TO DAY | String | GetString() | |
INTERVAL HOUR TO SECOND | TimeSpan | GetString() |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.