Hi Albert, Beermann, Albert [mailto:[EMAIL PROTECTED] wrote:
> I trie to sync to databases with loadercli. > I extract the structure of a table with catalogextract on > system a, drop the table on system b, catalogload on system b > I do this with a programm that works for all tables until now !!! > All tables have date and timestamp columns which look like this: > bestelldatum date NOT NULL DEFAULT '9999-12-31' > angelegt TIMESTAMP NOT NULL DEFAULT '9999-12-31 00:00:00.000' > > N ow my problem with table asbkopfbeweg > > catalogextract table asbkopfbeweg outstream 's_kopfbeweg' > > s_kopfbeweg: > > SQLMODE INTERNAL > // > CREATE TABLE "ASBKOPFBEWEG" > ( [snipped most of the column definitions and left only interesting ones] > "BESTELLDATUM" Date NOT NULL DEFAULT > '31.12.9999', > "RECHNUNGSDATUM" Date NOT NULL DEFAULT > '31.12.9999', > [...] > "ANGELEGT" Timestamp NOT NULL DEFAULT > '9999-12-31-00.00.00.000000', > "GEAENDERT" Timestamp NOT NULL DEFAULT > '9999-12-31-00.00.00.000000', > "GELOESCHT" Timestamp NOT NULL DEFAULT > '9999-12-31-00.00.00.000000', > [...] > ) > > Then i want to load the structure into another database. > > loadercli-- catalogload table asbkopfbeweg instream 's_kopfbeweg' > error -25010 > SQL error -3048 = invalid date format:internal (error > position 848[line: 1, col: 848]) > > Both databases are installed on a linux server , same kernel version, > both have date-time-format = 'EUR' > place a 'SET FORMAT EUR'-command into your command-file at the beginning and it'll do. We'll correct this error asap. Sorry for any inconvenience. Regards, Steffen -- Steffen Schildberg MaxDB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
