Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: FastExport return code
From:   Michael Larkins

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,


  <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