I think the fastload needs some more information about your datafile.
I used the dataload statement and added a few more at the end of the import statement, something like that:
ASCII DATE 'jjjj-mm-tt' BOOLEAN '1/0' SEPARATOR ',' TIME 'hh:mm:ss' DECIMAL '//./' NULL '' DELIMITER '"' TIMESTAMP 'jjjj-mm-tt hh:mm:ssnnnnnn'
... hope that helps
Greeting
Georg
[EMAIL PROTECTED] wrote:
Hi,
I have a problem with the import via repmcli
I created a data file with the following format:
01,01,ADP,1,1 02,01,AMP,1,1 . . .
and a the following command file:
FASTLOAD TABLE test id 1 what 2 dbaccession 3 isalive 4 ispublic 5
INFILE '/opt/sapdb/depend/bin/entry.data'
In the next step I tryed to import the data via repmcli -u <userid>,<password> -d SPECDB -b command.dat
All the time I got that message:
"Missing data for specified column WHAT"
If I try to import only one column it works but not if I try to import more than one column.
Can anyone help me.
Thanks
Marcel
Marcel Meier
Max-Planck-Institute for Molecular Plant Physiology Am M�hlenberg 1
14476 Golm
****************May the source be with you****************
This e-mail may contain trade secrets or privileged, undisclosed or otherwise confidential information. If you are not the intended recipient and have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal from your system. Thank you for your co-operation.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
