Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Unix FastExport problem: UTY4014 Access module error '34'
From:   Jeff Ohlman

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.


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