Chinaunix

标题: informix中update语句报错 [打印本页]

作者: ztj111 时间: 2011-08-25 13:03
标题: informix中update语句报错
create temp table shh
(
bankcode CHAR(12),
BusinessCode CHAR(15)
)
with no log;

load from jf1.unl delimiter '|'
insert into shh;

update prpjfcombus set bankcode=
(select a.bankcode from shh a
where a.BusinessCode=prpjfcombus.BusinessCode
);

运行上面语句报错：
391: Cannot insert a null into column (prpjfcombus.bankcode).
Error in line 4
Near character position 4

麻烦大家帮忙分析一下。

jf1.unl:
0801025500|898430159600500
0801025500|898430159604401
0801025500|898430159604501
0801025500|898430159604601
0801025500|898430159604701
0801025500|898430159604801
0801025500|898430159604901
0801025500|898430159605001
0801025500|898430159605101
0801025500|898430159605201
0801025500|898430159605301
0801025500|898430159605401
0801025500|898430163000234
0801025500|898430163000235
0801025500|898430163000236
0801025500|898430163000237
0801025500|898430163000238
0801025500|898430292231488
0801025500|898430163000239
0801025500|898430163000240
0801025500|898430163000241
0801025500|898430163000242
0801025500|898430163000243
0801025500|898430163000244
0801025500|898430163000267
0801025500|898430192230169
0801025500|898430359601506
0801025500|898430359601504
0801025500|898430359601500
0801025500|898430292231497
0801025500|898430292231491
0801025500|898430192230170
0801025500|898430192230171

作者: ztj111 时间: 2011-08-25 13:06
prpjfcombus表的结构
prpjfcombus
(
ComCode CHAR(

NOT NULL,
BusinessCode CHAR(15) NOT NULL,
BusinessName CHAR(40) NOT NULL,
BankCode CHAR(12) NOT NULL,
Flag CHAR(10),
);

作者: mujian1986 时间: 2011-08-25 15:47
update prpjfcombus set bankcode=
(select a.bankcode from shh a
where a.BusinessCode=prpjfcombus.BusinessCode
)
where BusinessCode in(select BusinessCode from shh);

作者: ztj111 时间: 2011-08-25 16:13
这样是可以的

作者: renxiao2003 时间: 2011-08-27 22:45
空限制啊。你的列有不允许空的。

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)