Archives of the TeradataForum

Message Posted: Wed, 25 Jul 2002 @ 03:02:38 GMT

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

Hi Mark:

I haven't ever seen any type of activity count in FastExport, which surprises me. If you are not outputting files with around 500K rows or more records, you might consider using BTEQ.

BTEQ has a variable called activitycount. It contains the number of rows associated with every SQL statement executed. So, you could use the following after your SELECT:

.if activitycount < 1 then .quit

If you need to use FastExport and on UNIX, you could use commands in your UNIX script to test the size of the file and determine whether the file is larger than 0 bytes and take the appropriate action based on that discovery. If you are on a mainframe, I don't know how you might good about determining the size and testing it.

Hope this helps,

Mike

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