I have a problem with the repmcli. I am trying to migrate from ADABAS-D to SAPDB and have to DATALOAD a table with approx. 500000 rows. There are basically only 3 columns that are relevant, so I used the COMPRESSED format. My input file looks like this:
1249,4530,MAEU6616757
1303,4532,MWCU9627960
1457,2200,GSTU2667222
1498,42G1,TRIU5893554
1517,45R1,MWCU3244965
1555,42G1,SEAU4865678
...
column1 primary key, integer
column2 text, varchar(8)
column3 text, varchar(12)
The command file I use is:
DATALOAD TABLE cont_base
cnt_num 1
cnt_isocode 2
cnt_ident 3
INFILE 'contbase.list'
Looks simple, but it does not work:
The target table contains more than the three specified columns, but none are mandetory (NOT NULL).Opened connection to REPLICATION SERVER at node local host. REPLICATION SERVER Log File: '/usr/sapdb/indep_data/wrk/repserver.log'User XYZ connected to database ABC on local host. DATALOAD TABLE cont_base cnt_num 1 cnt_isocode 2 cnt_ident 3 INFILE 'contbase.list' Error during execution -->-25319 Missing data for specified column CNT_ISOCODE. Defined maximum number of errors (1) reached
What am I missing?
Arne
--
Institute of Shipping Economics and Logistics http://www.isl.org/
Arne Gehlhaar mailto:[EMAIL PROTECTED]
Universitaetsallee GW1 Block A phone:+49.421.22096.49
D-28359 Bremen, Germany fax:+49.421.22096.55
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
