Thanks for your information, one more question. If I was attempting to complete this task on Window NT, would it be possible creating a pipe and using it. Thanks. Dre
Create a named pipe:
mknod /tmp/bcp-pipe p
Start a bcp-session:
bcp mydb..mytable out /tmp/bcp-pipe -c -Uuser -Sserver
And then you can read from that pipe in your perl program:
open FIFO, '/tmp/bcp-pipe' or die "cannot open /tmp/bcp-pipe: $!\n";
while (<FIFO>) {
print "bcp-data: $_";
}
close FIFO;