Tags for named pipes
SQL*Plus spool to Fastload via named pipe (Windows) is barely faster than by flat file.
I've got Fastload opening a named pipe, and I'm redirecting the output from a SQL*Plus script to the pipe in Windows. I assumed this would be far faster than allowing SQL*Plus to spool the result to a file locally, and fastload to import the flat file. Turns out it's not.
oracle windows performance fastload named pipes sql*plus
The NPAM Fallback file
The Teradata Named Pipe Access Module (NPAM) provides an inter-process communication link between a writer process (such as FastExport) and a reader process (such as FastLoad).  The NPAM can also be used by Teradata Parallel Transporter (TPT) for data transfer activity. This article discusses the Fallback file that is used by the NPAM.
teradata named pipes client data connector npam access modules fallback file named pipe data recovery check point v_tools
FastExport Access Module Error
Hello all: Does anyone know why FastExport would not be able to find the named pipe below?  Any thoughts?  Thank you for your help! The Named Pipes Access Module is installed (version 13.10.00.3). **** 09:56:52 UTY4019 Access module error '4' received during 'File open'
named pipes fastexport requested file not found
The Initialization process of the NPAM
The Teradata Named Pipe Access Module (NPAM) provides an inter-process communication link between a writer process (such as FastExport) and a reader process (such as FastLoad). The NPAM can also be used by Teradata Parallel Transporter (TPT) for data transfer. The reader process will initialize the NPAM module via an Initialization string and this article details the various parameters that are initialized during this process.
teradata named pipes parameters i/o npam data transfer access module initialization pipes initialization string v_tools
Different operating modes of the NPAM
The Teradata Named Pipe Access Module (NPAM) provides an inter-process communication link between a writer process (such as FastExport) and a reader process (such as FastLoad).  The NPAM can also be used by Teradata Parallel Transporter (TPT) for data transfer. This article details the different modes in which Named pipes are opened and used by NPAM for data transfer activity.
teradata named pipes function pipe npam data transfer blocking non-blocking operations operating modes v_tools
Understanding Named Pipe Access Module data transfer
The Teradata Named Pipe Access Module (NPAM) provides an inter-process communication link between a writer process (such as FastExport) and a reader process (such as FastLoad).
named pipes pipe named pipe archive npam data transfer axsmod v_tools
Sending data to Windows Named Pipe
Hi: I left this post on the main Teradata website forum, but I thought this might be more appropriate and perhaps get a response. Thanks for taking a look. I just found this little nook inside of Teradata and I'm glad it exists. I've created a Windows named pipe in a vb.net application using the System.IO.Pipes namespace. I'm creating a pipe, my process appears to be connecting to the pipe block and waiting to read and now I would just like to feed the pipe from Teradata.
.net named pipes fastexport