Re: Error in dbimport - "^M" in files .unl
Omar que tal
Verifique si en el Solaris hay un comando dos2unix, este, convierte el formato dos a unix.
Otra opcion,
Con sed hagalo asi:
Creen un script con estas lineas
sed s/\\^M\\$// $1>temp$$
mv temp$$ $1
sed /\\^\\$/d $1>temp$$
mv temp$$ $1
Luego ejecute : nombre_script Nombre_archivo_dos
Un saludo
> ----- Original Message -----
> From: Omaluva <omaluva@yahoo.com>
> To: informix-list@iiug.org
> Subject: Error in dbimport - "^M" in files .unl
> Date: Tue, 5 Dec 2006 08:59:00 -0600 (CST)
>
>
> Hi all,
>
> I have a problem, i did dbexport on informix 9.30 - Windows
> 2000, then pass by ftp to Informix 9.30 on Unix Solaris, here, when
> i try to import a database, get a following error during the
> dbimport :
>
> { TABLE "informix".perfil_de_usuario row size = 71 number of
> columns = 5 index size
> = 73 }
> { unload file name = perfi00102.unl number of rows = 222657 }
> create table "informix".perfil_de_usuario
> (
> cod_sistema varchar(2) not null ,
> codigorol varchar(4) not null ,
> cod_usuario varchar(20) not null ,
> userid varchar(20),
> funcid varchar(20),
> primary key (cod_sistema,codigorol,cod_usuario)
> ) extent size 54 next size 16 lock mode page;
> Load file has different number of columns than table
>
> Then, when I see to file perfi00102.unl :
> $ vi perfi00102.unl
> S|01|SEG|020|0|||^M
> S|03|SEG|021|0|||^M
> S|03|SEG|029|0|||^M
> S|03|SEG|028|0|||^M
> S|03|SEG|027|0|||^M
> S|02|SEG|014|0|||^M>
> How to avoid to obtain this "^M" in all files .unl, that's the problem..!
> Of UNIX to UNIX there is no problem with dbimport.
>
> How to solve this problem?
>
> Thanks a lot.
>
> Sorry by my english.
>
> Omar.
>
>
>
>
> Omar LUQUE Valdivia
> Informix Database Administrator
> Dirección de Telemática - Marina de Guerra del Perú
> Av. La Marina Cdra. 36 s/n, La Perla - Callao, Lima - Peru
> Telf : (511) 614-2900 (511) 562-3900 Ext. 2277 2265
> E-mail : Luque001@marina.mil.pe
> Cel. 9 639-7201
>
>
>
>
>
> __________________________________________________
> Correo Yahoo!
> Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
> Regístrate ya - http://correo.espanol.yahoo.com/
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
--
_______________________________________________
Get your free email from http://www.linuxmail.org
Powered by Outblaze