Re: Help with dbload
Quoting Leif Van Horn...
}
} 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.
}
As strange as this sounds... try making all the key words in your
command file lower-case instead of upper-case.
DAS
--
David Snyder @ Snide Computer Services - Folcroft, PA Current Release
is db4glgen-3.9
UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com