用bcp导入时,报如下错误:
Starting copy...
CTLIB Message: - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed. col = 6
CTLIB Message: - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed. col = 6
CTLIB Message: - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed. col = 6
CTLIB Message: - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed. col = 6
CTLIB Message: - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed. col = 6
CTLIB Message: - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed. col = 6
CTLIB Message: - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed. col = 6
bcp copy in failed
0 rows copied.
Clock Time (ms.): total = 125
存在原因:数据库中表的字段不能为空,并且没有默认值,但bcp里第6列有为空的值。
所以无法插入记录。