Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 28 Sep 2006 @ 17:36:47 GMT


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


Subj:   Fast Export Error - Single AMP Select statement has been issued in Fast Export
 
From:   Mehra, Tanu

Hi,

On executing the fast export script, I get the following error:

"UTY8713 RDBMS failure, 3695: Single AMP Select statement has been issued in FastExport."


Following is the script, that we are executing:

     .LOGTABLE DEV.Table_log;
     .LOGON ;
     .BEGIN EXPORT
     TENACITY 5
     SLEEP 1;

     .EXPORT OUTFILE  c:\load_file.txt MODE RECORD
     FORMAT TEXT;

     select distinct cast(
            cast(A as char(10))||
            cast(B as char(60))
            as char(70))
     from DEV.Table
     where not trim(A) in ('NA','')
     ;
     .END EXPORT;

     .LOGOFF;

Any help would be greatly appreciated.


Thanks and Regards,

Tanu.



     
  <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: 27 Dec 2016