I'm a newbie trying to get some simple stuff done to find out more about sapdb. So far so good except for populating my database.
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: ================================ create table RANKINGS ( DIVISION_ID char(4) not null, TEAM_ID char(20) not null, RANKING_DATE date not NULL ) Successfully executed 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 ================================ Thanks for any help, Steve Meyfroidt _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
