Hi,
I am having a strange problem with the Data loader,
I have a script like:
// Imports data from import file into the database.
SET MAXERRORCOUNT 2000
// comment here
DATALOAD TABLE LD_TABLE
UPDATE DUPLICATES
LD_CODE 01
LD_GOLD 02
LD_NF 03
LD_NM 04
LD_NL 05
LD_SF 06
LD_PN 07
LD_FE 08
LD_LC 09
LD_SN 10 DEFAULT NULL
LD_ET 11 DEFAULT NULL
INFILE 'F:\prd\data\import.csv' COMPRESSED SEPARATOR ';' DELIMITER ''
Note how the last two fields are set as "DEFAULT NULL"
The table layout has only LD_CODE marked as "NOT NULL". Most of the
fields are strings, but LS_SN is an integer. LD_CODE also has an index on
it.
I purposely left LD_SN as nullable, because many of the rows of the impur
gilr leave it blank, and we need those rows too.
Yet when I run the script, I get:
-25319
Missing data for specified column LD_SN.
Successfully executed
What is even more odd is that we have other import scripts that work the
same way and - actually work. None of those appear to use Integer for
such fields, but varchars and smallints are used. Another odd thing is
that the last field, LD_ET (which is a varchar) imports fine, null or not.
This is with SAPDB 7.3.0.15 on Win2k. (There are various reasons we
haven't updated it to 7.4 or 7.5 yet), and with an updated 7.3 loader.
This problem is somewhat critical, so I hope someone has an idea
(otherwise, I will make an app to load the data via odbc...)
Thank you,
Noah Silva
Atofina IS&T - Sr. Programmer Analyst
(215) 419 - 7916
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
