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
收起