dotConnect for DB2 Documentation
Devart.Data.DB2 Namespace / DB2Parameter Class / Size Property

In This Topic
    Size Property (DB2Parameter)
    In This Topic
    Gets or sets the maximum size, in bytes, of the data within the column.
    Syntax
    'Declaration
     
    Public Overrides Property Size As Integer
    public override int Size {get; set;}

    Property Value

    The maximum size, in bytes, of the data within the column. The default value is inferred from the parameter value.
    Remarks
    The Size property is used for binary and string types.

    For variable-length data types, the Size property describes the maximum amount of data to transmit to the server. For example, for a string value, the Size property could be used to limit the amount of data sent to the server to the first one hundred bytes.

    For nonstring data types and ANSI string data, the Size property refers to the number of bytes. For Unicode string data, the Size property refers to the number of characters. The count for strings does not include the terminating character.

    If not explicitly set, the value of Size is inferred from the actual size of the specified parameter value.

    For fixed-width data types, the value of Size is ignored. It can be retrieved for informational purposes, and returns the maximum amount of bytes the provider uses when transmitting the value of the parameter to the server.

    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