All Forums Tools
Ek186009 3 posts Joined 11/13
17 Jan 2014
Error while running FastExport script

Hi,
I'm phasing some issues while executing Teradata FastExport script. Each time it gives an arror as 
 UTY8717 An 'EXPORT' statement was entered without a preceding 'Begin Export' statement.
My script is
.logtable DB.LOGTABLE;
.logon <ipaddr>/user,password
.begin EXPORT SESSIONS 4;
.export OUTFILE Dir/Filename FORMAT TEXT MODE RECORD;
SELECT
..........................
from Table ;
.end export;
.logoff;
 
I mentioned .Begin Export in my statement,still it is throwing an error.
Please help me to resolve this issue.
Thanks,
Eswar

Eshwar, Teradata India Pvt Ltd
Ek186009 3 posts Joined 11/13
17 Jan 2014

ok

Eshwar,
Teradata India Pvt Ltd

Raja_KT 1246 posts Joined 07/09
17 Jan 2014

Somewhere a syntax problem, maybe a semi colon at end .logon <ipaddr>/user,password???
I guess the driectory, fname etc are fine,
Cheers,

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Ek186009 3 posts Joined 11/13
20 Jan 2014

Thanks Raja K Thaw,
Your assumption is correct.
Semicolon was missed at the end of .logon <ipaddr>/user,password ;
 
 

Eshwar,
Teradata India Pvt Ltd

You must sign in to leave a comment.