From: Jean-Michel OLTRA (jm.oltraespinasse.net)
Date: Mon Jun 28 2004 - 15:57:13 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

        bonjour,

Le mardi 29 juin 2004, maxdbceroriesgo.co.cr a écrit...

> How to use DATALOAD with nulls replacement on file of type COMPRESSED ASCII

> "10-01-01-05-010","EDGAR GREGORY
> SHEPHERD","D","","60000.00","0.00","60000.00","0.00"

> 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

may be ?

dataload table ......saldo_inicial 4 DEFAULT NULL....compressed ascii
NULL ''

--
jm

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]