Help with dbload
Posted in 1993
Topics: General Discussion
I use Informix version 4.00 on a 3b2 and cannot get
dbload to work properly. The comand file looks like this:
FILE "Newreport.out" DELIMITER "|" 21 ;
INSERT INTO acd (pdate,ptime,vdn,acd,exten,tpeg,tusg,avg_svc_time,
taban,textaban,qpeg,qusg,avg_que_time,max_calls,max_que_time,
pct_time_exc,vpeg,vusg,vaban,success,status)
VALUES (f01,f02,f03,f04,f05,f06,f07,f08,f09,f10,f11,f12,f13,f14,f15,f16,
f17,f18,f19,f20,f21);
Resulting in this error:
DBLOAD Load Utility INFORMIX-SQL Version 4.00.UG1
Copyright (C) Informix Software, Inc., 1984-1989
Software Serial Number AAA#C293637
FILE "results/Newreport.out" DELIMITER "|" 21 ;
Syntax error occurs on statement above.
Line 1 Character 30
Character 30 would be the D of DELIMITER. Help is greatly appreciated.
Leif Van Horn
Telecommunications Services
University of Colorado at Boulder