Schildberg, Steffen wrote:
Hi Armin,
Armin Haaf wrote:
I tried the way with dataextract for dataload and it did not work:
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...
I think there is some misunderstanding concering the COMPRESSED keyword.
Neither COMPRESSED (in SAP DB) nor COMPRESS (in ADABAS) have any relation
to real compression. It only means that trailing/leading blanks in data
fields are cut off and the data is separated by separators and not described
using absolute position specification.
I know, that what i mean with "there are many spaces..."
It would be extremely helpful to have the command you tried to execute and
some snippet of the data that should be inserted. There
are some incompatibilities in the command syntax between ADABAS and SAP DB that
must be solved prior to successfully loading. But I'm sure we'll make it
together ;-).
Load and data file are attached, here is what replication manager says:
/opt/sapdb/depend/bin/repmcli -d xxx -n xxx -u xxx,xxx -b /tmp/ppo/ANSICHTEN.load
Opened connection to REPLICATION SERVER at node local host.
REPLICATION SERVER Log File: '/var/opt/sapdb/indep_data/wrk/repserver.log'
User ppo connected to database devel on gaia.
SQLMODE INTERNAL
Successfully executed
CREATE TABLE "PPO"."ANSICHTEN" (
"BEZEICHNUNG " VARCHAR (80) ASCII ,
"FAVORIT " VARCHAR (18) ASCII ,
"USERID " VARCHAR (80) ASCII
)
Successfully executed
DATALOAD TABLE "PPO"."ANSICHTEN"
"BEZEICHNUNG" 1-80 CHAR DEFAULT NULL
"FAVORIT" 84-101 CHAR DEFAULT NULL
"USERID" 105-184 CHAR DEFAULT NULL
INFILE '/tmp/ppo/ANSICHTEN.data '
DEC '/ /./'
DATE 'INTERNAL'
TIME 'INTERNAL'
TIMESTAMP 'INTERNAL'
NULL '? '
BOOLEAN 'TRUE /FALSE '
Error during execution
-->-25233
Some column descriptions with end position but file format is COMPRESSED.
Thanx
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] (_)�(_)
test | ?
| test
test |
test1 | test
test |
test2 | test
SQLMODE INTERNAL
/ *
CREATE TABLE "PPO"."ANSICHTEN" (
"BEZEICHNUNG " VARCHAR (80) ASCII ,
"FAVORIT " VARCHAR (18) ASCII ,
"USERID " VARCHAR (80) ASCII
)
/ *
DATALOAD TABLE "PPO"."ANSICHTEN"
"BEZEICHNUNG" 1-80 CHAR DEFAULT NULL
"FAVORIT" 84-101 CHAR DEFAULT NULL
"USERID" 105-184 CHAR DEFAULT NULL
INFILE '/tmp/ppo/ANSICHTEN.data '
DEC '/ /./'
DATE 'INTERNAL'
TIME 'INTERNAL'
TIMESTAMP 'INTERNAL'
NULL '? '
BOOLEAN 'TRUE /FALSE '
/ *
/ *
