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

    See Also