Bulk Copy Operation on a Table with Identity Columns

Perform a bulk-copy operation on a table with identity columns.

When transferring rows in a bulk-copy-in operation involving identity columns, the values for identity columns are not, by default, specified. The values are generated by the server.

For example :

import sybpydb
conn = sybpydb.connect(dsn="user=sa;bulklogin=true;chainxacts=off")
cur = conn.cursor()
cur.execute("create table mytable (empid int identity, empname varchar(20))")
            cur.close()
            blk = conn.blkcursor()

# Start bulk copy in operation. Do not specify values for identity columns.
# Values will be generated by the server.
blk.copy(name="mytable", direction="in")
blk.rowxfer(["Joanne"])
blk.rowxfer(["John"])
blk.done()

IdStartnum property to specify the initial starting value for identity columns.

For example:

# Specify starting identity column value of 11 for the copy operation.
blk.copy(name="mytable", direction="in", properties="IdStartNum=11")
blk.rowxfer(["Max"])
blk.rowxfer(["Danny"])
blk.done()

Identity property to explicitly specify; the values for identity columns by the application.

For example:

# Values for identity columns will have to be specified.
blk.copy(name="mytable", direction="in", properties="identity=on")
blk.rowxfer([21, "Maya"])
blk.rowxfer([22, "Uma"])
blk.done()