Specifies the data type of a field, property, or DB2eParameter.
[Visual Basic]
Public Enum DB2eType
[C#]
public enum DB2eType
The following table shows mappings between DB2eType data types,
DB2 Everyplace data types (shown in parentheses), and .NET Framework types.
| Member | Desciption |
|---|---|
| SmallInt | Exact numeric value with precision 5 and scale 0 (signed: -32,768 <= n <= 32,767, unsigned: 0 <= n <= 65,535) (SMALLINT). This maps to Int16. |
| Integer | Exact numeric value with precision 10 and scale 0 (signed: -2[31] <= n <= 2[31] - 1, unsigned:0 <= n <= 2[32] - 1) (INTEGER). This maps to Int32. |
| Char | A fixed-length character string (CHAR). This maps to String. |
| VarChar | A variable-length character string (VARCHAR). This maps to String. |
| Decimal | Signed, exact, numeric value with a precision of at least p and scale s, where 1 <= p <= 31 and s <= p. (DECIMAL). This maps to Decimal. |
| Date | Date data in the format yyyy-mm-dd (DATE). This maps to DateTime. |
| Time | Time data in the format hh:mm:ss (TIME). This maps to TimeSpan. |
| Timestamp | Timestamp data in the format yyyy-mm-dd-hh.mm.ss.zzzzzz (TIMESTAMP). This maps to DateTime. |
| Blob | A stream of binary data (BLOB). This maps to an Array of type Byte. |
Requirements
NameSpace: IBM.Data.DB2.DB2e Namespace