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" <jsarabia@xxxxxxxxxx>
To: <maxdb@xxxxxxxxxxxxxxx>
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/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx