all the times I've posted something for getting help, i'm fixing the errors directly by my own self. Before the post I've tried for more than 6 hours to fix. Next time I will post my prob after 5 min. :-)
The prob was related by the missing delimiters of the first 2 fields.
But with the wrong Error-Message it was hard to find (is the database ignoring the fields without delimiter???).
Normaly we are working with formatted files, so I have not known that I have to set the delimiter for all fields.
Hi to all,
i've some probs with loadercli on a production machine.
System is SuSE 8.2.
It's the first Load for this table after upgrading from 7.4
Have tried the whole day to load the data from a csv file to the database. Then I've tried it with only one row.
All the times the same Error.
Then I've taken only 1 row for testing. No chance. I'm getting grazy with this.
I can't see anything wrong.
This is the data row for Test: 14288;815;"XO";"Andere Orte";"andere Ziele";"Andere L�nder";"";
USE USER "XXXX" * SERVERDB "XXXX"
// *
// M USER: 'XXXX' on DB: 'XXXX' // *
// M START 20031211 00185944
// *
dataload table R_GIATA_ORTE
"ORT_ID" 1
"ZGB_ID" 2
"LAND_CODE" 3 DEFAULT NULL
"ORT_NAME" 4 DEFAULT NULL
"ZGB_NAME" 5 DEFAULT NULL
"LAND_NAME" 6 DEFAULT NULL
"AIRPORTS" 7 DEFAULT NULL
INFILE '/usr/local/adabas/LastMinute/giata/zuordnungen/giata_orte.txt' COMPRESSED
DELIMITER '"'
SEPARATOR ';'
NULL ''
// *
// M Error at record 1 in infile.
// E -25319: Missing data for specified column LAND_NAME.
// M Last transaction committed at input record 0
// *
// M Sum of inserted records 0, sum of rejected records 1
// *
Hope somebody can help.
With best regards
Albert
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
