Hi,
I have two questions regarding the replication manager (using Suse Linux
7.2):
- When using compressed input file format, null values are not handled
properly. If the value is ommitted (two double quotes, or two subsequent
commas) it is not imported at all reporting an error. If I use the NULL input
definition, instead of null the String is inserted. See definitiona at the
end
of the file
- This is probably something easy that I am missing at the moment: When I try
to use the repmcli not being the sapdb user I get the following error message.
When I connect as sapdb everything works fine.
> repmcli -u dba,dba -d TST -n localhost -r localhost -b empimport.cmd
12-30 19:52:10 2177 ERR -11608 COMMUNIC sql03_request: wrong connection
state,
state is 'requested'
Opened connection to REPLICATION SERVER at node localhost.
Speicherzugriffsfehler
Best Regards & Thanks, Karl
------------------------------------------------------------------------------------------------------
Command and Data Files
DATALOAD
TABLE employees
empId 1
firstName 2
lastName 3
birthday 4
sex 5
INFILE '/home/bankkar/cvs/sapdbbook/src/part2/employees.dat'
DATE 'DD.MM.YYYY'
DATALOAD
TABLE salaries
empId 1
salary 2
remark 3
bonus 4
INFILE '/home/bankkar/cvs/sapdbbook/src/part2/salaries.dat'
SEPARATOR ';'
DELIMITER '%'
NULL '??'
File employees.dat
1,Franz,Mueller,02.04.1966,M
2,Hans Eric,Gudmusson,02.04.1971,M
3,Sima,Zarandi,24.07.1963,F
4,Claus Giselher,Bush,02.03.1968,M
5,Hillary,Stanton,01.03.1954,F
File salaries.dat
%1%;%45762%;%Higher Bonus Next Year%;%2000%
%2%;%57548%;??;%40000%
%3%;%65221%;%Make her a manager%;%15000%
%4%;%34234%;%"Get rid of him"%;%17000%;
%5%;%50031%;??;%15000%
