How to call Fastexport script in Unix

Database

How to call Fastexport script in Unix

Hi Experts,

I have created fastexport script and its working fine untill i pass the $HOME path for logon. when i give below syntax it gives me error. 

Can somebody tell me how to handle it in unix.

.LOGTABLE errors;

.run file $HOME/.tdlogon;

.BEGIN EXPORT;

.EXPORT OUTFILE paymentfile_FE.txt MODE RECORD FORMAT TEXT;

Select 

CAST (BANK_NUM AS CHAR(2))  (title ''),

CAST (ACCT_NUM AS CHAR(10))  (title ''),

CAST(INC_TRXN_CD AS CHAR(4))   (title ''),

CAST ((inc_amt*100 (Format '9(15)')) AS CHAR(15))  (title ''),

     case when FFL_DESC like '%ASSOC EXEMPT%' then CAST ('Assoc Exempt  '  AS CHAR(14))

          when FFL_DESC like '%EXCEPTION LOG%' then CAST ( 'CashIncentive ' AS CHAR(14))

          When FFL_DESC = 'NP STANDARD' then CAST ('Atm Incentive '  AS CHAR(14))

          WHEN PROMO_CD = 'RAF' THEN CAST ( 'ReferralPromo ' AS CHAR(14)) else  CAST ('CashPromotion ' AS CHAR(14)) end    (title '')

FROM UD466.FF_PRCSS 

where  ELG_FLG = 'Y' 

ORDER BY bank_num;

.END EXPORT;

.LOGOFF;

Logs:

Error:-

0001 .LOGTABLE errors;

0002 .run file = $HOME/.tdlogon;

**** 13:36:53 UTY0005 Bad data in the RUN command at position 10, the name beginning with "="

     is not a valid file identifier.

**** 13:36:53 UTY2410 Total processor time used = '0 Seconds'

     .       Start : 13:36:53 - SAT APR 05, 2014

     .       End   : 13:36:53 - SAT APR 05, 2014

     .       Highest return code encountered = '8'.

4 REPLIES

Re: How to call Fastexport script in Unix

echo $HOME.

See this the content : ls -ltra $HOME/.tdlogon if it shows up.

Also see the .profile  content. See the PATH settings for fastexport (fexp).

Cheers,

Re: How to call Fastexport script in Unix

Thanks Raja . How should i check the path settings for faxtexport?

Re: How to call Fastexport script in Unix

Actually same path and everything is working in Bteqs but not in fastexports and tpump scripts.

Re: How to call Fastexport script in Unix

I suggest you better ask your  Unix admin for the $PATH settings. Of course you can do it, using the global find where the fastexport is there. Also you can get clue from your bteq path settings normally.