dotConnect for DB2 Documentation
Devart.Data.DB2 Namespace / DB2Type Enumeration

In This Topic
    DB2Type Enumeration
    In This Topic
    Specifies the data type of a field or a parameter.
    Syntax
    'Declaration
     
    Public Enum DB2Type 
       Inherits System.Enum
       Implements System.IComparableSystem.IConvertibleSystem.IFormattable 
    Members
    MemberDescription
    BigIntThe BIGINT DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Int64 or System.Int64 integer.
    BinaryAn array of bytes. Corresponds to CHAR, VARCHAR, LONG VARCHAR, GRAPHIC, VARGRAPHIC and LONG VARGRAPHIC DB2 data types. May be represented as Devart.Data.DB2.DB2Types.DB2Binary or array of System.Byte.
    BinaryXmlBinary XML format that you can use to transmit data to and from a DB2 server version 10.1 and later. May be represented as Devart.Data.DB2.DB2Types.DB2Xml or System.String.
    BlobAn array of bytes. Corresponds to the BLOB DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Blob or array of System.Byte.
    CharA fixed-length string. Corresponds to the CHAR DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2String or System.Char.
    ClobA large string of characters. Corresponds to the CLOB DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Clob or System.String.
    CursorAn DB2 CURSOR. This type does not have corresponding .NET Framework type. The DB2DataReader object can be used to retrieve cursor content.
    DatalinkA reference to an object stored external to a database. This type does not have corresponding .NET Framework type.
    DateThe DATE DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Date, System.DateTime, or System.String.
    DbClobA large string of characters. Corresponds to the DbCLOB DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Clob or System.String.
    DecimalA decimal value. Corresponds to the DECIMAL DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Decimal or System.Decimal.
    DecimalFloatA floating-point decimal value. Corresponds to the DECIMALFLOAT DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2DecimalFloat or System.Decimal.
    DoubleA double-precision floating-point value. Corresponds to the DOUBLE PRECISION DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Double or System.Double.
    DynArrayCorresponds to a dynamic array such as a UniData® or UniVerse record or select list. For example, you may use this type as a type of an input parameter to send an Input Array to a stored procedure.
    FloatA single-precision floating-point value. Corresponds to the FLOAT DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Double or System.Double.
    GraphicA string of characters. Corresponds to the GRAPHIC DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2String or System.String.
    IntegerThe INT DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Int32 or System.Int32 integer.
    InvalidInvalid DB2 type.
    LongVarBinaryAn array of bytes. Corresponds to the LONG VARCHAR FOR BIT DATA DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Binary or array of System.Byte.
    LongVarCharA string of characters. Corresponds to the LONG VARCHAR DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2String or System.String.
    LongVarGraphicA string of characters. Corresponds to the LONG VARGRAPHIC DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2String or System.String.
    NumericA decimal value. Corresponds to the DECIMAL DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Decimal or System.Decimal.
    RealA floating-point number. Corresponds to the REAL DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Real or System.Single.
    Real370A floating-point number. Corresponds to the REAL DB2 for OS/390 database type, which is represented in IBM 370 notation. May be represented as Devart.Data.DB2.DB2Types.DB2Real370 or System.Single.
    RowIdAn array of bytes that represent the identifier of a row. Corresponds to the ROWID DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2RowId or or array of System.Byte.
    SmallIntThe SMALLINT DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Int16 or System.Int16 integer.
    TimeA string that represents the time of day. Corresponds to the TIME DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Time, System.DateTime, or System.String.
    TimestampA string that represents a timestamp. Corresponds to the TIMESTAMP DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2TimeStamp, System.DateTime, or System.String.
    TimeStampWithTimeZoneA string that represents a timestamp with time zone. Corresponds to the TIMESTAMP WITH TIME ZONE DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2TimeStamp, System.DateTime, or System.String.
    VarBinaryAn array of bytes. Corresponds to the VARBINARY DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Binary or array of System.Byte.
    VarCharA string of characters. Corresponds to the VARCHAR DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2String or System.Char.
    VarGraphicA string of characters. Corresponds to the VARGRAPHIC DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2String or System.Char.
    XmlAn XML document. Corresponds to the XML DB2 data type. May be represented as Devart.Data.DB2.DB2Types.DB2Xml or System.Xml.
    Remarks
    This table shows mappings between DB2Type values, DB2 data types, Microsoft .NET Framework types.
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             Devart.Data.DB2.DB2Type

    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also