All Forums Tools
terankit 77 posts Joined 03/12
16 Jul 2012
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

terankit 77 posts Joined 03/12
16 Jul 2012

hi all,

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

feinholz 1234 posts Joined 05/08
16 Jul 2012

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

--SteveF

You must sign in to leave a comment.