[Python-sybase-misc] Bulkcopy in NULL values?

[Warren, J. <wa...@kb...>]

Hi,=20

I don't suppose anyone would have a way to bulkcopy in NULL values?

For example (__version__ =3D '0.38') :-

from Sybase import *

c =3D connect ('TEST_DS', 'sa', 'password', bulkcopy=3D1, auto_commit=3D1)
c.execute("CREATE TABLE #t1 (a int, b INT NULL)")
b=3Dc.bulkcopy('#t1')
for r in range(32):
    b.rowxfer([r,None])   # None represents NULL when selected or
bulkcopied out
    if r %5 =3D=3D 4:
        ret =3D b.batch()
ret =3D b.done()

This results in :-

Sybase.Error: blk_rowxfer_mult in

Many thanks,
James.

--=20
This message may contain confidential, proprietary, or legally privileged i=
nformation. No confidentiality or privilege is waived by any transmission t=
o an unintended recipient. If you are not an intended recipient, please not=
ify the sender and delete this message immediately. Any views expressed in =
this message are those of the sender, not those of any entity within the KB=
C Financial Products group of companies (together referred to as "KBC FP").=
=20

This message does not create any obligation, contractual or otherwise, on t=
he part of KBC FP. It is not an offer (or solicitation of an offer) of, or =
a recommendation to buy or sell, any financial product. Any prices or other=
 values included in this message are indicative only, and do not necessaril=
y represent current market prices, prices at which KBC FP would enter into =
a transaction, or prices at which similar transactions may be carried on KB=
C FP's own books. The information contained in this message is provided "as=
 is", without representations or warranties, express or implied, of any kin=
d. Past performance is not indicative of future returns.