001;2009-05-25;1005;mu;1;ZAP1D;10.249.10.227;00000049;FNC:MS=14530667,NA=0;EXECUTED;
054;2009-05-25;1005;mu;;ZAH1D;10.236.18.225;00000124;FSC:MS=14702549,NA=1;NOT ACCEPTED
FAULT CODE 154;
我在弄sql*load,但是control文件写不对,以上是两条记录,麻烦帮我看看这个怎么编写control文件,谢谢了!!
054;2009-05-25;1005;mu;;ZAH1D;10.236.18.225;00000124;FSC:MS=14702549,NA=1;NOT ACCEPTED
FAULT CODE 154;
我在弄sql*load,但是control文件写不对,以上是两条记录,麻烦帮我看看这个怎么编写control文件,谢谢了!!
append into table zc.t1
fields terminated by X'59'
trailing nullcols
(c1,c2,c3,c4,c5,c6,c7,c8,c9)