Archives of the TeradataForum

Message Posted: Tue, 22 Oct 2002 @ 17:02:26 GMT

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

FastExport was actually the first option tried due to expected performance benefits. Unfortunately, producing a fixed length, non- delimited, character data record did not seem possible. It was fine if you wanted to take the data into another Teradata utility, but that is not the desired result. I was trying to avoid this without writing additional OUTMOD stuff, although even with the BTEQ option I'm still having to run a post processing awk script to append 70 bytes to the end of each record due to the file width limitations of BTEQ.

Unfortunately, the 3rd party product has a fixed, unmodifiable input requirement, which we've been able to successfully meet using SQL*Plus in Oracle. I'm new to Teradata and I'm not as familiar with the utilities, and the manuals are seriously lacking in adequate examples which hasn't helped matters.

Attached is what I tried with FastExport. Perhaps you can advise me as to what's wrong with the parm settings. I see that you said to use a FORMAT of BINARY and a MODE of RECORD for example. Anything else?

.LOGTABLE fexp ;
.LOGON azb,az00 ;
.BEGIN EXPORT SESSIONS 1 ;
.EXPORT OUTFILE /export/symmetry_file.dat FORMAT TEXT OUTLIMIT 100000000;

Same SQL statement

.END EXPORT ;
.LOGOFF ;

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