Hi Steve, sorry for the delay. Steve Meyfroidt wrote: > > It doesn't appear that repmcli understands the DATE command, or fails > somewhere else, using the latest Windows 7.3 sapdb download > (plus latest repm patch on the patches FTP). > > I've cut down my case to a bare minimum below. Note that I've > successfully > used repmcli with similar data that doesn't contain any "date" types. > > Here is the error: > [snipped table description] > > DATALOAD TABLE rankings > division_id 1 > team_id 2 > ranking_date 6 > INFILE 'D:\football\database\2. load_teams\test.csv' COMPRESSED > DATE 'yyyymmdd' > DELIMITER '' > > Error during execution > -->-25301 > Invalid input for date or time column: 20020803 > > Defined maximum number of errors (1) reached > ================================ > > And here is the data file: > > ================================ > s0 ,Celtic , 2,Dunfermline , 1, 20020803 > s0 ,Dundee , 1,Hearts , 1, 20020803 > ================================ > The problem is the white space in front of the date. This must clearly be handled by RepMan and is accepted as a bug :-( It'll get fixed with the next version. You can avoid this error by removing the blank. Your data would then look like this: s0 ,Celtic , 2,Dunfermline , 1,20020803 s0 ,Dundee , 1,Hearts , 1,20020803
Instead of defining the date format you may also use the default date format of RepMan thats called INTERNAL and looks the same than the one you define. What I'm wondering about is the fact that date and time are aligned like numbers in your data file not like strings. Did you create the data using RepMan? Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
