How to use DATALOAD with nulls replacement on file of type COMPRESSED ASCII
ej.
"10-01-01-05-010","EDGAR GREGORY SHEPHERD","D","","60000.00","0.00","60000.00","0.00"
create table tmp_catalogo (
cuenta varchar(30),
nombre varchar(255),
tipo char(1),
saldo_inicial fixed(16,2),
saldo_actual fixed(16,2),
saldo_anterior fixed(16,2),
debitos fixed(16,2),
creditos fixed(16,2)
)dataload table dba.tmp_catalogo cuenta 1 char nombre 2 char tipo 3 char saldo_inicial 4 char saldo_actual 5 saldo_anterior 6 debitos 7 creditos 8 instream file '/tmp/conta0/cuentas.txt' compressed ascii
ERR -25319 Missing data for specified column SALDO_INICIAL.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
