Fast Export Error

Tools
Enthusiast

Fast Export Error

Hi All,

I am newbie to TeraData. I ran the below code for FastExport:

.LOGTABLE jbhatt.example_log;

.LOGON 127.0.0.1/jbhatt,sample;

.BEGIN EXPORT;

.EXPORT OUTFILE example_export.dat;

sel top 10 * FROM samples;

.END EXPORT;

.LOGOFF;

I got the following output:

.LOGTABLE jbhatt.example_log;

 *** Error: Unrecognized command LOGTABLE

 Enter your logon or BTEQ command:

.LOGON 127.0.0.1/jbhatt,

 *** Logon successfully completed.

 *** Teradata Database Release is 14.00.05.02

 *** Teradata Database Version is 14.00.05.03

 *** Transaction Semantics are BTET.

 *** Session Character Set Name is 'ASCII'.

 *** Total elapsed time was 1 second.

 BTEQ -- Enter your SQL request or BTEQ command:

.BEGIN EXPORT;

 *** Error: Unrecognized command BEGIN

 BTEQ -- Enter your SQL request or BTEQ command:

.EXPORT OUTFILE example_export.dat;

 *** Syntax Error: Expected FILE or DDNAME keyword, not "OUTFILE".

 *** Warning: Extra text found after command.

              The text 'example_export....' not processed (ignored).

 BTEQ -- Enter your SQL request or BTEQ command:

sel top 10 * FROM samples;

 *** Query completed. 10 rows found. 18 columns returned.

 *** Total elapsed time was 1 second.

  S.No F_ID X_ID                         Z

-------------------- ----------- ---------------------------------------- -

              155133    16012000 ?                                        F

              155133    16012000 ?                                        F

              155133    16012000 ?                                        F

              155133    16012000 ?                                        F

              155133    16012000 ?                                        F

              155133    16012000 ?                                        F

              155133    16012000 ?                                        F

              155133    16012000 ?                                        F

              155133    16012000 ?                                        F

              155133    16012000 ?                                        F

 BTEQ -- Enter your SQL request or BTEQ command:

.END EXPORT;

 *** Error: Unrecognized command END

 BTEQ -- Enter your SQL request or BTEQ command:

 *** Warning: EOF on INPUT stream.

.LOGOFF;

 *** You are now logged off from the DBC.

Please help me understand. where i am going wrong.... Thanks in Advance.

2 REPLIES
Junior Contributor

Re: Fast Export Error

If you read the error message "Enter your logon or BTEQ command" you will notice that you used BTEQ for running this script :-)

Try fexp instead.

Enthusiast

Re: Fast Export Error

Thanks dnoeth.. :).