Oninit cdi / Archive
Talk to an expert →

RE: Error in dbimport - "^M" in files .unl

Posted in 2006

Topics: Storage & Space Management, Security, Permissions & Auditing, Data Types & Schema Design, Migration, Import/Export & Data Conversion, Platform-Specific Issues

Mike Badar — — source: Usenet: comp.databases.informix

Omar, > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org] On Behalf Of Omaluva > Sent: Tuesday, December 05, 2006 7:59 AM > To: informix-list@iiug.org > Cc: iiug-esp@iiug.org > Subject: Error in dbimport - "^M" in files .unl > > 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, Did you specify ASCII as the transfer protocol? DOS> ftp solaris username password FTP> ascii FTP> put <file> > 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 Give this a try and let us know. Mike Badar ESRI Professional Services 1 International Ct. Broomfield, CO 80021 mbadar@esri.com 303-449-7779 www.esri.com > > > __________________________________________________ > Correo Yahoo! > Espacio para todos tus mensajes, antivirus y antispam ¡gratis! > Regístrate ya - http://correo.espanol.yahoo.com/ >

↪ replying to Mike Badar
=?ISO-8859-1?Q?Susanne_H=FCsing?= — — source: Usenet: comp.databases.informix

Hi, use dos2unix-conmmand to convert from DOS format to ISO format dos2unix [ -ascii ] [ -iso ] [ -7 ] originalfile converted file look at the man-pages on the unix-box s. huesing Mike Badar schrieb: > Omar, > > > >> -----Original Message----- >> From: informix-list-bounces@iiug.org >> [mailto:informix-list-bounces@iiug.org] On Behalf Of Omaluva >> Sent: Tuesday, December 05, 2006 7:59 AM >> To: informix-list@iiug.org >> Cc: iiug-esp@iiug.org >> Subject: Error in dbimport - "^M" in files .unl >> >> 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, > > Did you specify ASCII as the transfer protocol? > > DOS> ftp solaris > username > password > FTP> ascii > FTP> put <file> > > >> 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 > > > Give this a try and let us know. > > Mike Badar > ESRI Professional Services > 1 International Ct. > Broomfield, CO 80021 > mbadar@esri.com > 303-449-7779 > www.esri.com >> >> >> __________________________________________________ >> Correo Yahoo! >> Espacio para todos tus mensajes, antivirus y antispam 'gratis! >> Reg'strate ya - http://correo.espanol.yahoo.com/ >>

Glossary