Archives of the TeradataForum

Message Posted: Fri, 24 Aug 2001 @ 13:27:52 GMT

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

We have implemented the named-pipe solution at my current site. It works very well. This solution can be enhanced by kicking off a background process that compresses the output and then sends the output to the split function. You can also pipe directly to an mload or fastload from the fastexport. Note that BTEQ in v2r3 doesn't like this stuff.

Example:

mknod mypipe p || exit 1  #create the pipe

cat mypipe | compress -c | split -20 -b -a 3 - out. &  #start bg process,
output goes to out.xaa etc

BG_PID=$!  #bg process pid

fexp < myscript.sql #export in current prodess in fg

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