I am trying to run the below script in fxp:
.EXPORT OUTFILE samples111
Sel top 10 * from db.table1
In the Interactive Mode i gave it as below:
fxp < fxpExample.txt
I am getting an error. This is the 1st time i am learning about FastExport. Please help me how to proceed.. THanks
You should always specify which error you get.
FastExport commands must start with a period. Both Fexp and SQL commands must be terminated by a semicolon:
.EXPORT OUTFILE samples111;
Sel top 10 * from db.table1;
I had forgot to include the semicolon while posting this issue. Sorry for that.
While runnin the script in my PC i had included period in the beginnin and a semicolon in the end of the code.
I got the answer from google.
fxp < /home/jugal/fexport.txt