windows - NZLoad using Pipe File Syntax Issue -
i looking bulk load big data large text files netezza table , looking @ using named-pipe option. however, having trouble getting started. test using windows 64-bit machine , calling nzload ssis script task , passing arguments in. following online guide saved file loadme.bat . can tell me if syntax correct in file? or way off base , can't of work in control file? when tried running error stating there syntax error , expected datafile or mkfifo: '<'.
in .bat file:
mkfifo: mkfifo pipefile cat c:\testing\dev\rawfiles\testfile.txt > pipefile nzload -host nzdev -u user -pw pwd -db nzdw -delim "\n" -df pipefile datafile loadme.dat { database ebidw tablename ld_test_table. }
calling ssis, argument line i'm using:
-host nzdev -u user -pw pwd -cf loadme.bat
any appreciated. can table load fine without using pipe-file it's not driver issue or don't think. figured either wrote incorrectly in .bat file or approach isn't correct , misinterpreted guide read.
Comments
Post a Comment