Re: Dbexport/Dbimport through pipe giving prob

In article <6ikrap$dlu$1@news.xmission.com>, sanjeev sagar <sanjeevsagar@rocketmail.com> writes > > > >Informix - 7.23 On-Line DSA >O/S - Solaris 2.4 > > >I was trying to do dbexport and then dbimport through >pipe. dbexport works fine b'coz i can see that >exported file which includes all dll and load >statemnet But > >when i say dbimport, it works but not completely. It >creates database and couple of tables then it says >"Corrupt Data". > >For further testing, i created sports7 database and >do following operation > >mknod /tmp/mypipe p >dbexport sports7 -t /tmp/mypipe -b 512 -s 23000000 >on another session >dd if=/tmp/mypipe of=test.sql bs=512k > >it creats test.sql then i tried dbimport[drop >database first] > >dbimport sports7 -t /tmp/mypipe -b 512 -s 23000000 >on another session >dd if=test.sql of=/tmp/mypipe bs=512k > >it creats sports7 database but after couple of table >loading it breaks and says > >"corrupt data" > >I tried the jobs in background but no help. > >Now i am ready for guru expert advise. Pls let me know > >I would appreciate that and thanks a ton! in advance. > >Sanjeev > > > > >_________________________________________________________ >DO YOU YAHOO!? >Get your free @yahoo.com address at http://mail.yahoo.com > You cannot dbimport from a named pipe. It is not supported. What happens is that the read call returns less than the number of bytes requested in the read call. e.g. 1000 instead of 1024 bytes. Informix then assumes the read has failed. Sorry but it does not work.. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care