Archives of the TeradataForum
Message Posted: Wed, 25 Jul 2002 @ 03:02:38 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|