Home Page for the TeradataForum
 

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023