I have been trying to make bteq exported data to be fastloaded using named pipes on windows and cygwin. But fastload is failing and not waiting for the bteq export to populate the pipe. Please find my scripts below.
SELECT JOB_NAME, SYSTEM_NAME, MAIN_ID||',' FROM mytable ORDER BY 1;
Error shown: --------------- I/O Error on File Open: 34, Text: Could not open the requested Pipe, "\\Sessionfolder\my.pipe", because: The filename, directory name, or volume label syntax is incorrect.
Do we need to have the file path as the one mentioned above for pipes to work with axsmod? or can we have any ordinary name? I am calling the fastload script first and then calling the bteq hoping that fastload will wait in the stpe of "Starting to send rows to RDBMS". But its not happening. What am I doing wrong? Can any body help with samples of named pipe implementations and axsmod samples?
Re: Named Pipe with axsmod bteq export to fastload
Thanks Carlos. Now I am trying the same on windows.. But still no result... Its failing with the same error. If I remove the file server path and give the target file as a local file then fastload is failing with a message box - 'Fastload.exe - An application referenced memory at location......'. Am I doing some syntax mistake or am I missing some thing?