Bulk Copy Support

Support for a bulk copy operation is an extension to the Python DBAPI. It enables you to bulk copy rows.

An example for a bulk copy in operation:

import syDbpydb
conn = sybpydb.connect(dsn="user=john;bulklogin=true;chainxacts=off")
cur = conn.cursor()
cur.execute("create table mytable (id int identity, name varchar(20))")
cur.close()

blk = conn.blkcursor()
blk.copy("mytable", direction="in", )
blk.rowxfer(["Mark"])
blk.rowxfer(["Leanne"])
blk.rowxfer(["Stanley"])
blk.done()
blk.close()

conn.close()