Re: Help with dbload
}
}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
On our 3B2 with 4.0, dbload will not work with the quotation marks around the
path name, even though the manual specifically states to use them. Give it
a try.
-----------------------------------------------------------------------------
Bob Kane Internet: bob@worms-emh2.army.mil (IP 134.235.9.2)
TechDyn Systems Voice: (049) 6241-487306 (WORMS, GERMANY)
CMR 421, BOX 706 Fax: (049) 6241-49560
APO AE 09056 CIS: 71054,2661