why FastExport never works for me?

Tools & Utilities
Enthusiast

why FastExport never works for me?

I want to generate a flat file but FastExport doesn't work for me. Following are the source codes and log file. Could anybody do me a favor to figure it out? I am wondering wheather FastExport is installed or not in my machine, how could I check this? Thanks in advance!!!

===source codes====
bteq &1

.logon $dbServ/$dbUser,$dbPass
database $dbName;

.begin export session 20;

.export outfile fardaily1050 mode record format text;

sel * from fardaily where locationid=1050 and productnumber in (441807
,698925
,67691
,731427
,477550
);

.end export;

.if errorcode <> 0 then .quit 99

.logoff
.quit 0
EOF

=========log file=========

.begin export session 20;
*** Error: Unrecognized command BEGIN
+---------+---------+---------+---------+---------+---------+---------+----

.export outfile fardaily1050 mode record format text;
*** Syntax Error: Expected FILE or DDNAME keyword, not "OUTFILE".
*** Warning: Extra text found after command.
The text 'fardaily1050 mode record forma' not processed (ignored).
+---------+---------+---------+---------+---------+---------+---------+----

sel * from fardaily where locationid=1050 and productnumber in (441807
,698925
,67691
,731427
,477550
);

*** Query completed. 5 rows found. 33 columns returned.
*** Total elapsed time was 1 second.

locationtype locationid productnumber fieldtype vendornumber d
------------ ---------- ------------- --------- ------------ --------------
S 01050 441807 1 0000000xxxxx
S 01050 698925 1 0000000xxxxx
S 01050 67691 1 0000000xxxxx
S 01050 731427 1 000000000xxx
S 01050 477550 1 0000000xxxxx

+---------+---------+---------+---------+---------+---------+---------+----

.end export;
*** Error: Unrecognized command END
+---------+---------+---------+---------+---------+---------+---------+----

2 REPLIES
Enthusiast

Re: why FastExport never works for me?

I am wondering if you are mixing up between bteq and fast export.... they are two different utilities... you invoke the fast export utility via the executable fexp

I suggest you to go through some samples in the fast export manual to get some basic acquaintance with the tool... might save you some time and trouble ....
Enthusiast

Re: why FastExport never works for me?

Thank you, u r right!
I should run with fexp but I didn't :-(.
I am working on that now. Thanks again.