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

In This Topic
    DB2LoaderOptions Enumeration
    In This Topic
    Defines specific behaviors for writing data to server.
    Syntax
    'Declaration
     
    Public Enum DB2LoaderOptions 
       Inherits System.Enum
       Implements System.IComparableSystem.IConvertibleSystem.IFormattable 
    Members
    MemberDescription
    DefaultUse the default values for all options.
    KeepIdentity

    Preserve source identity values. Identity columns can be kept only if they are not defined as GENERATED ALWAYS. If they are defined as GENERATED ALWAYS, the WriteToServer method throws an exception.

    When not specified, identity values are assigned by the destination.

    TableLock

    Assign a table lock for the duration of the data load operation. Other applications are not permitted to update the table during the data load operation.

    When not specified, table reads are allowed on the table for rows that existed before the copy operation.

    TruncateClear the data in the destination table before the data load operation starts.
    Inheritance Hierarchy

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

    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