I am trying to create a 1 line file depending upon certain condition using export.
.EXPORT file= Trig.txt
.SET RECORDMODE OFF;
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 ' ')
The issue is:
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
For PROCESS_TYP = "Y" it is displaying nly record till 76 byte.