Hi Jonatahan, try change the end to
infile 'c:\agent.data' COMPRESSED DELIMITER '' if the data is CSV. It would help if you can post a sample of the data you try to load -Zavier ----- Original Message ----- From: "Jonathan Sarabia" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 27, 2004 8:08 AM Subject: Dataload error Hi, I have a file like this: Agent.data 32,Agente de prueba de carga,1,1155 A table Agent like this: CREATE TABLE Agent ( sAgent VARCHAR(5) NOT NULL, sDescript VARCHAR(40) NOT NULL, sChangeType VARCHAR(5) NULL, nUser_id INTEGER NOT NULL, dCompdate DATE NOT NULL, PRIMARY KEY(sAgent) And I am trying to load data by using this command: loadercli>dataload table dba.agent sAgent 1 sDescript 2 sChangeType 3 nIser_id 4 dCompdate DATE infile 'c:\agent.data' ERR -25243 Error parsing timestamp mask: Date mask incomplete Anybody have an idea? Thanks in advance!! Jonathan -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
