Issues in fast export

Tools & Utilities
Enthusiast

Issues in fast export

Hi all,

I am trying to create a 1 line file depending upon certain condition using export.

.LOGON ;

.EXPORT file= Trig.txt

.SET RECORDMODE OFF;

SELECT                                                     

(CASE                                                      

     PROCESS_TYP                                       

WHEN 'Y' THEN trim(COALESCE(cast('/work/cmpweb/cmd/vendor/Runload.sh'||' '||'/asp/vendor/'||FILENAME AS CHAR(97)),''))

WHEN 'N' THEN TRIM(CAST(CNTRL_ID AS CHAR(4)))

END) (title ' ')

FROM                                                       

     tbl1                       

WHERE condition;                                     

.END EXPORT;

.LOGOFF

The issue is:

1)

when it found PROCESS_TYP = "N": it is first creating a line (i think for "Y") as "-----" and then in next line writing the desired CNTRL_ID

2)

For PROCESS_TYP = "Y" it is displaying nly record till 76 byte.

Please help.

Terankit

2 REPLIES
Enthusiast

Re: Issues in fast export

hi all,

The first line is coming as "--------" for both types of outputs.I am using (title '') even then it is coming.

Teradata Employee

Re: Issues in fast export

That looks like a BTEQ script, not a FastExport script.

-- SteveF