Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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;
     .EXPORT OUTFILE emp.txt
     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';

In emp table empno is the primary index.

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


Dhanraj P

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023