I am trying following command: DATAEXTRACT FOR DATALOAD TABLE TEST_AUTH OUTFILE 'TEST_AUTH.control' OUTFILE 'TEST_AUTH.data'
It creates for me these two files filled with datas. But then I want to import data again. When I run:
//
DATALOAD TABLE "TEST_AUTH"
"I1" 1 CHAR DEFAULT NULL
"T1" 2 CHAR DEFAULT NULL
"USER_CREATED" 3 CHAR DEFAULT NULL
"TIME_CREATED" 4 CHAR DEFAULT NULL
"USER_MODIFIED" 5 CHAR DEFAULT NULL
"TIME_MODIFIED" 6 CHAR DEFAULT NULL
"CRC" 7 CHAR DEFAULT NULL
INFILE 'TEST_AUTH.data'
COMPRESSED ASCII
DECIMAL '/ /./'
DATE INTERNAL
TIME INTERNAL
TIMESTAMP INTERNAL
NULL '? '
BOOLEAN 'TRUE/FALSE'
//
This is part of the TEST_AUTH.control file, first statement for creating table I deleted.
It still gives me error: "Invalid input for date or time column: 2003-06-05 11:45:58. "
What I am doing wrong ? There is specified that timestamp is INTERNAL, also adding TIMESTAMP INTERNAL to the first command doesn't help.
Thanks, Tom
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
