Archives of the TeradataForum

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

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

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>>