Hi Steffen, Thank you very much for your collaboration, in fact the error was the connection to the database instance. Also I want to thank Zavier and Jean-Michel!!!
Best regards, Jonathan In fact, that -----Original Message----- From: Schildberg, Steffen [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 2:28 AM To: [EMAIL PROTECTED] Subject: RE: Dataload error Hi Jonathan, Jonathan Sarabia [mailto:[EMAIL PROTECTED] wrote: > > 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 > I suppose you use Loader version 7.5.00.05, right? Further I'd suppose you did not open a db connection before running the DATALOAD command. This gives a misleading error message in the version you use. So to run an arbitrary load/extract command you either have to supply the connect options in loadercli call (-u and -d options) and have the loadercli do the connect implicitely for you or to run a USE USER <user name> <password> SERVERDB <db name> command prior to processing the load/extract command. All other things mentioned by Zavier and Jean-Michel apply, too. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin -- 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]
