Watz wrote:
Hi,
as far as I know you cannot load data files created with TABLEEXTRACT USER because this is a binary data file the data format is not binary compatible with sapdb (anymore?).
If you search the archive however you find examples and instructions of how a migration of data from adabas to sapdb can (probably) be done with a CATALOGEXTRACT and DATAEXTRACT FOR DATALOAD combination.
I'm working on a little java tool for making the whole process easier (there have to be some changes done in the DDL files crated with xload, and that can be alot of work on large catalogs). Currently I'm once again lacking the time to continue working on it.
Marco
I tried the way with dataextract for dataload and it did not work:
I want to migrate the table test in our adabas system to a sapdb:
With adabas xload I do the dataextract:
DATAEXTRACT FOR DATALOAD table test
outfile /tmp/test.load
outfile /tmp/test.data
After changing SQLMODE to internal, I used the replication manager:
repmcli -d test -n testserver -u test,test -b /tmp/test.load
It creates the table and stops on importing with the following message:
Error during execution
-->-25233
Some column descriptions with end position but file format is COMPRESSED.
But the test.data file is not compressed, there are many spaces...
Any ideas
Armin
--
Armin Haaf, mercatis information systems GmbH
Marlene-Dietrich-Str. 5 Fon +49 (0) 731 98588 - 615 ___o
89231 Neu-Ulm, Germany Fax +49 (0) 731 98588 - 511 _\ <_
http://www.mercatis.de mailto:[EMAIL PROTECTED] (_)�(_)
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
