Hi,
I've got a problem loading some data into a table using the loadercli.exe on
a W2K-machine.
I've got a table, which was created as:
CREATE TABLE "TEST"."TEST"(
"A" Varchar (28) ASCII NOT NULL,
"B" Varchar (255) ASCII,
"C" Varchar (127) ASCII,
"D" Fixed (20,0) NOT NULL,
"E" Varchar (7) ASCII,
"F" Fixed (20,0),
"G" Varchar (28) ASCII NOT NULL,
"H" Fixed (20,0) NOT NULL,
PRIMARY KEY ("A")
)
To load data into this table, I created a loader-file which is defined as:
FASTLOAD TABLE TEST
A 1
B 2
C 3
D 4
E 5 DEFAULT NULL
F 6 DEFAULT NULL
G 7
H 8
INFILE 'c:\in.data' COMPRESSED
DELIMITER ''
SEPARATOR '|'
NULL ''
A typical data-line from the infile is:
xxxx|yyy|zzz|1|||tt|1
which means, that columns E and F are null in most cases.
When I try to load this file I get every time the following error:
Error during execution
-->-25303
Input value does not match key order or range specification.
When I first tried a loader-file without defining "Default null" I got
Error during execution
-->-25319
Missing data for specified column F.
That's why I started to use "Default null" options.
Has anybody a clue, how to configure the loader-file for the given data?
Once a simple loader test was successfull, but after the load, the table was
set to "read only". I read somewhere that a database-backup will solve this
issue and set the table status back. But is this the only way to reset the
"read only"-flag for a table after a load?`
Thanks for help and best regards,
Oliver Pick
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
