Archives of the TeradataForum
Message Posted: Thu, 26 May 2005 @ 12:11:36 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|