Re: high-performance loader to named pipe
Doug,
Unload and loading to a named pipe works great.
The named pipe cannot be on an NFS mounted system.
An example of using a named pipe with HPL.
Set your unload device to pipe
"compress > /your/direcory/andfile.unl.Z"
Set you load device to pipe
"zcat /your/directory/andfile.unl.Z"
That is a simple example.
Now for something that does not have standard output.
mknod or mkfifo /home/informix/namedpipe.unl
dbaccess database <<EOF &
unload to "/home/informix/namedpipe.unl"
select * from yourtable;EOF
Set your device in HPL to Pipe
"cat /home/informix/namedpipe.unl"
As soon as dbaccess writes a line the HPL will
load the line. The namedpipe.unl file will not
grow very much. You are just bouncing the data
off of the pipe.
You can use this from a remote machine with
the rsh command. Have HPL call rsh on another
machine and just load the std.out.
Thanks
>
> This is a multi-part message in MIME format.
> --------------1C57620D84E8C4943B9E9E0B
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Hi all..
>
> I am trying to test out the functionality of the
> High-performance loader
> to a named pipe. Unfortunately it doesn't seem to
> work. It looks like it
> dumps out the data but the ipload job hangs when
> trying to do the close.
> But there is nothing that shows up in the pipe.
> Has anyone used named pipes with ipload? I am using
> a 9.21.uc1 product.
>
> tnx.....
>
> --------------1C57620D84E8C4943B9E9E0B
> Content-Type: text/x-vcard; charset=us-ascii;
> name="doug.mcallister.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Doug McAllister
> Content-Disposition: attachment;
> filename="doug.mcallister.vcf"
>
> begin:vcard
> n:McAllister;Doug
> tel;work:(603) 791-5688
> x-mozilla-html:TRUE
> url:www.fidelity.com
> org:Fidelity Investments
> version:2.1
> email;internet:doug.mcallister@fmr.com
> title:Consulting DBA
> adr;quoted-printable:;;2 Contra
> Way=0D=0AT1Q;Merrimack;NH;03054;USA
> fn:Doug McAllister
> end:vcard
>
> --------------1C57620D84E8C4943B9E9E0B--
>
>
>
>
>
-------------------------------------------------------------------------------------------------------------------------------
> The information transmitted is intended only for the
> person or entity to
> which it is addressed and may contain confidential
> and/or privileged
> material. Any review, retransmission, dissemination
> or other use of, or
> taking of any action in reliance upon, this
> information by persons or
> entities other than the intended recipient is
> prohibited. If you received
> this in error, please contact the sender and delete
> the material from any
> computer.
>
__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/