Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 26 May 2005 @ 12:11:36 GMT


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


Subj:   Error 3695 in Fast Export - A Single AMP Select
 
From:   Dhanraj Palani

Hi all,

I am getting an error in fastexport , error code 3695, as per the docs the error message is

3695 A Single AMP Select statement has been issued in FastExport.

Explanation: The user has attempted to execute a Select statement which accesses a single AMP while in FastExport.

This is most likely with equality constraints on Primary or Unique Secondary Indexes. Use regular SQL for such queries.


Following is the piece of code which is giving the above error

     .LOGTABLE utillog;
     .LOGON test/test,test;
     .BEGIN EXPORT;
     .EXPORT OUTFILE emp.txt
      MODE RECORD
      FORMAT TEXT;
     SELECT ename (CHAR(20)),
            job    (CHAR(20)),
            sal    (format '99999.99')  (char(15)),
            comm   (format '99999.99')  (CHAR(10)),
            mgr    (format '999999')    (CHAR(6)),
            empno  (format 'ZZZZ')      (CHAR(10))
     from emp
     where empno = '7839';
     .END EXPORT;
     .LOGOFF;

In emp table empno is the primary index.

Can anyone please let me know how to resolve this issue.


Regards,

Dhanraj P



     
  <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