Re: Pipe into SQL*Loader

From: Frank O'Carroll <ocarroll_at_icot.or.jp>
Date: Thu, 12 Aug 1993 02:33:14 GMT
Message-ID: <OCARROLL.93Aug12113314_at_ss151.icot.or.jp>


>From: ttg242_at_newton.sps.mot.com (David Thornewill von Essen)
>Subject: Pipe into SQL*Loader
>Message-ID: <1993Aug11.202513.12254_at_newsgate.sps.mot.com>
>Date: Wed, 11 Aug 1993 20:25:13 GMT

>In a unix environment (specifically SUN 4.1.3) can I pipe data into
>sqlldr? If so, how? Or point me to the correct manual, I don't seem
>to able able to find this in mine.

I use the mknod command to make a named pipe, and then tell SQL*LOADER to read from the pipe as though it were a regular file.

EG to load data from a compressed file:

	/usr/etc/mknod /tmp/sqlpipe p
	uncompress < data.Z > /tmp/sqlpipe &
	sqlload sqlpipe.ctl

Where sqlpipe.ctl has an INFILE statement mentioning /tmp/sqlpipe Note that the asynchronous & on the command outputting to the pipe is ESSENTIAL. Received on Thu Aug 12 1993 - 04:33:14 CEST

Original text of this message