Re: Dbexport/Import NT to solaris
At 17:26 01/01/15 +1300, Andy Jiang wrote:
Hi Andy.
Please use following command on Solaris.
% cd xxx.exp
% wc -l *.unl
And check line count <-> {rows = xxx} in xxx.sql
If count is not same, newline is corrupted?
Unix: LF(0x0a)
NT: CR(0x0d) + LF(0x0a)
Please input following command on ftp prompt
ftp > ascii
Regards.
>Hi everyone
>--------
>I post a question last December as following:
>I got problem when try to dbimport a database which is dbexported from
>informix on NT into IDS 2000 on Solaris.
>
>The error message of dbimport is:
>load file has different number of columns than table.
>
>I check the files under *.exp in solaris, exactly the same size as *.exp in
>NT, I copy through use FTP.
>
>What is wrong here?
>-------
>
>
>OK. I know what is wrong. It is CR/LF to LF problem. On NT box, when I do
>dbexport, the exported *.unl files have CR/LF as end line, but unix requires
>LF as end line when I do dbimport.
>Does anyone know how to do the mapping? or how to change behavior of NT or
>Unix box.
>
>Regards
>
>Andy Jiang
>
>
>
--
$B0KF#Ci%F%/%N%5%$%(%s%93t<02q<R(B
INFORMIX$B1D6H?d?JIt(B $B2.86!!6P(B
Tsutomu.Ogiwara@ctc-g.co.jp/ifmx-tech@ctc-g.co.jp
102-0074 $BEl5~ET@iBeED6h6eCJFn(B2-3-14
TEL.03-5212-4880 FAX.03-5212-4889