All Forums Database
Niesh20us 78 posts Joined 06/13
05 Apr 2014
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'.

Raja_KT 1246 posts Joined 07/09
06 Apr 2014

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,
 

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.

Niesh20us 78 posts Joined 06/13
07 Apr 2014

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

Niesh20us 78 posts Joined 06/13
07 Apr 2014

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

Raja_KT 1246 posts Joined 07/09
07 Apr 2014

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.

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.

You must sign in to leave a comment.