> [Karl Banke wrote]
> Subject: dataextract for import
>
>
> Hi,
>
> the dataextract for dataload feature seems to be broken. The
> following command
> produces the results below on Suse 7.2.
>
> DATAEXTRACT FOR DATALOAD TABLE employees
> OUTFILE 'employees.cmd'
> OUTFILE 'employees.dat'
>
>
> Opened connection to REPLICATION SERVER at node localhost.
> REPLICATION SERVER Log File:
> '/var/opt/sapdb/indep_data/wrk/repserver.log'
>
> User test connected to database TST on localhost.
> DATAEXTRACT FOR DATALOAD TABLE employees
> OUTFILE 'employees.cmd'
> OUTFILE 'employees.dat'
> Replication server error (-4 : 'protocol error')
>
> Some error(s) occurred running command.
> ---> See log file(s) for more information.
>
> The dat file is empty. In addition the created cmd file is a
> bit strange.
> Lots of DATE don't you think.
> / *
> CREATE TABLE "TEST"."EMPLOYEES"
> (
> "BIRTHDAY" Date,
> "EMPID" Integer,
> "FIRSTNAME" Varchar (100) ASCII NOT NULL,
> "LASTNAME" Varchar (100) ASCII NOT NULL,
> "SEX" Char (1) ASCII,
> PRIMARY KEY ("EMPID")
> )
> /
> DATALOAD TABLE "TEST"."EMPLOYEES"
> "EMPID" 1 CHAR
> "FIRSTNAME" 2 CHAR
> "LASTNAME" 3 CHAR
> "BIRTHDAY" 4 CHAR DEFAULT NULL
> "SEX" 5 CHAR DEFAULT NULL
> INFILE 'employees.dat'
> DEC '/ /./'
> DATE 'INTERNAL'
> DATE 'INTERNAL'
> DATE 'INTERNAL'
> NULL '? '
> BOOLEAN 'TRUE/FALSE'
>
> Regards, Karl
>
