Zavier, I've tried what you just told me and the same error occurs. By the way, the file I am trying to load is (Agent.data) and contains the record described below:
32,Test agent for the load,1,1155 Best regards, Jonathan -----Original Message----- From: Zavier Sheran [mailto:[EMAIL PROTECTED] Sent: Thursday, May 27, 2004 10:19 AM To: maxdb Subject: Re: Dataload error 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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
