Hello Everybody !
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"
(
"RECHNUNGSNR" Char (10) ASCII NOT NULL DEFAULT ' ',
"STADRESSSTAMMID" Char (10) ASCII NOT NULL DEFAULT
' ',
"STNLSTAMMID" Char (10) ASCII NOT NULL DEFAULT ' ',
"STKUNDENSTAMMID" Char (10) ASCII NOT NULL DEFAULT
' ',
"STVERTRAGSSTAMMID" Char (10) ASCII NOT NULL
DEFAULT ' ',
"STZAHLUNGSBEDINGUNGID" Char (10) ASCII NOT NULL
DEFAULT ' ',
"RECHNUNGSART" Char (1) ASCII NOT NULL DEFAULT ' ',
"BEZUGSRECHNR" Char (10) ASCII NOT NULL DEFAULT '
',
"RECHNUNGSSUMME" Fixed (10,2) NOT NULL DEFAULT
0.00,
"ZUABSCHLAG" Fixed (10,2) NOT NULL DEFAULT
0.00,
"BESTELLDATUM" Date NOT NULL DEFAULT '31.12.9999',
"RECHNUNGSDATUM" Date NOT NULL DEFAULT
'31.12.9999',
"RGKOPIEN" Fixed (1,0) NOT NULL DEFAULT 0,
"ANLAGENKZ" Fixed (1,0) NOT NULL DEFAULT 0,
"INTERNKZ" Fixed (1,0) NOT NULL DEFAULT 0,
"BESTELLNR" Char (40) ASCII NOT NULL DEFAULT ' ',
"BEZUGSJAHR" Char (4) ASCII NOT NULL DEFAULT ' ',
"BEZUGSMONAT" Char (2) ASCII NOT NULL DEFAULT ' ',
"FIPERIODEJAHR" Char (4) ASCII NOT NULL DEFAULT '
',
"FIPERIODEMONAT" Char (2) ASCII NOT NULL DEFAULT '
',
"SAPBELEGNR" Char (10) ASCII NOT NULL DEFAULT ' ',
"BARCODE" Char (10) ASCII NOT NULL DEFAULT ' ',
"MWSTKZ" Char (2) ASCII NOT NULL DEFAULT ' ',
"PARTNERBANKTYP" Char (4) ASCII NOT NULL DEFAULT '
',
"ZAHLWEG" Char (1) ASCII NOT NULL DEFAULT ' ',
"MAHNSPERRE" Char (1) ASCII NOT NULL DEFAULT ' ',
"MAHNTEXT" Char (40) ASCII NOT NULL DEFAULT ' ',
"RECHNUNGSINFO" Char (40) ASCII NOT NULL DEFAULT '
',
"RGOK" Char (1) ASCII NOT NULL DEFAULT ' ',
"RZNR" Char (4) ASCII NOT NULL DEFAULT ' ',
"SAMMELKZ" Char (2) ASCII NOT NULL DEFAULT ' ',
"EDIFAKTKZ" Fixed (1,0) NOT NULL DEFAULT 0,
"FAKTKZ" Fixed (1,0) NOT NULL DEFAULT 0,
"HALBKZ" Fixed (1,0) NOT NULL DEFAULT 0,
"ZWISCHENSUMMEKZ" Fixed (1,0) NOT NULL DEFAULT 0,
"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',
"A_BENUTZER" Char (20) ASCII NOT NULL DEFAULT ' ',
"G_BENUTZER" Char (20) ASCII NOT NULL DEFAULT ' ',
"L_BENUTZER" Char (20) ASCII NOT NULL DEFAULT ' ',
PRIMARY KEY ("RECHNUNGSNR")
)
//
CREATE INDEX "ASBKOPFBEWEGSTVERTRAGSSTAMMID" ON "ASBKOPFBEWEG"
("STVERTRAGSSTAMMID" ASC )
//
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'
When i create the table manualy:
create table asbkopfbeweg .....
...............
"bestelldatum date NOT NULL DEFAULT '9999-12-31' ," +;
.................
everything is ok !
Nevertheless the outstream of the catalogextract command looks like:
..........
"BESTELLDATUM" Date NOT NULL DEFAULT '31.12.9999',
..................
Any help welcomed
Albert
'''''
'''''''''
(0 0)
+---------oOO-----------(_)------------------------------+
| Tel: 0541/5841-868 |
| Fax: 0541/5841-869 |
| Mail: mailto:[EMAIL PROTECTED] |
| Internet: http://www.piepenbrock.de <http://www.piepenbrock.de/>
|
+--------------------------------------oOO----------------+
|__|__|
|| ||
ooO Ooo
