Hi Oliver,
The described behavior is a bug and will be fixed in one of the next
versions of the
Replication Manager.
To get 'empty' strings loaded you need to apply a workaround: you have to
include at
least one space sign between the separators for every 'empty' string. That
means your
datafile would look like this
"0160-050P000";"AT01";"5744.28"; ; ; ; ; ;"417.44";;
"0160-050P001";"AT01";"5744.28"; ; ; ; ; ;"417.44";;
[...]
However, loading 'empty' strings is only possible for character-type
columns. Trying to
load those strings in numeric or long columns will fail.
Hope this helps.
Regards
Steffen
--
steffen.schildberg@stripped
SAP DB, SAP Labs Berlin
> Hi,
>
> I'd like to input data in compressed format:
>
> "0160-050P000";"AT01";"5744.28";;;;;;"417.44";;
> "0160-050P001";"AT01";"5744.28";;;;;;"417.44";;
> [...]
>
> My repserver.log says:
>
> / *
> / M START 20001018 00185742
> / *
> DATALOAD TABLE Sap_Material_Master
> SAP_MATERIAL_NUMBER 1
> SAP_SALES_ORG 2
> SAP_MATERIAL_LOCAL_LIST 3
> PROCESS_STATUS 4
> SAP_SALES_STATUS 5
> SAP_MATERIAL_PRICE_GROUP 6
> SAP_PRODUCT_GROUP 7
> SAP_UNIT_OF_MEASURE 8
> SAP_MATERIAL_EURO_LIST_PRICE 9
> SAP_PRODUCT_LINE 10
> SAP_PRODUCT_TYPE 11
> INFILE '/home/share/archiv/symbol/Sap_Material_Master.txt'
> SEPARATOR ';';
>
> / *
> / M Error at line 1 in infile.
> / E -25325: Missing data for specified column PROCESS_STATUS.
> / M Last transaction committed at input line 0
> / *
> / M Sum of inserted lines 0, sum of rejected lines 1
> / *
> / M Releasing user connection (USER: 'OV').
> / *
>
> Obviously it doesn't import empty fields (first one is
> PROCESS_STATUS).
> How can I achieve this?
>
> Thanks!
>
> Oliver
>
