Archives of the TeradataForum

Message Posted: Fri, 15 Apr 2005 @ 06:16:54 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Connecting to a Fastload Named Pipe from non-TD program

From:		Dieter Noeth

Eric Rivard wrote:

Thanks for the help. I am executing the FastLoad from a script, then I am trying to tap into the pipe from a C# program (which calls a win32 api, CallNamedPipe) to write the data. I am getting "access is denied". I have tried other API calls, such as "CreateFile", but I get a "named pipes are busy" error. How did you accomplish it? Thanks again!!!! I would love to make this thing work!!!!!!!

Geoffrey's solution was for a shell script on Unix.

On Windows it's different:
First the reader opens the pipe and then the writer.
Once i wrote a program in Pascal to feed a FastLoad and i remember lots of troubles with Named Pipes. But when i used a simple file everything worked fine:

     assignfile(f, '<\\.\pipe\loadpipe>');
     rewrite(f);
     Writeln(f, ...);
     closefile(f);

And don't forget the Named Pipe access module in your FadtLoad script:

     AXSMOD np_AXSMOD.dll;

     DEFINE
     ...
     FILE = <\\.\pipe\loadpipe>;

Start the FastLad and when it consumes 100% CPU (waiting for the Pipe) start your program.

Btw, does anybody know how to use WINDOWS command line to open/write a Named Pipe for Fastload? E.g. Unzip a file and pipe it to FastLoad?

Dieter


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference