[SOLVED] Special Characters in Hold File while doing IBI.FIL
I am trying to create a hold file which feeds data to a dropdown list using our custom js framework. Following is the fex procedure.
-DEFAULTH &A = 'All';
SET HOLDLIST=PRINTONLY
SET ASNAMES = ON
SET PAGE = NOLEAD
ENGINE SQLORA SET DEFAULT_CONNECTION wmbi
SQL SQLORA
SELECT
Distinct loc_regn_num,
'<option value="' || loc_regn_num || '">' || loc_regn_num||'-'||loc_regn_nm || '</option>' AS listvalue
FROM
loc_dim
where loc_stat_cd = 'A'
and loc_regn_num is not null
and LOC_OPEN_DT is not null
and LOC_CLOSE_DT > SYSDATE
ORDER BY loc_regn_num
;
TABLE FILE SQLOUT
PRINT LISTVALUE AS ''
BY LOC_REGN_NUM NOPRINT
ON TABLE HOLD AS TMP
END
-RUN
-HTMLFORM BEGIN
<option value="ALL" Selected>&A</option>
!IBI.FIL.TMP;
-HTMLFORM END
I have tried different options but wasn't able to figure it out. Am i doing something wrong in creating the hold file?This message has been edited. Last edited by: FP Mod Chuck,
Insert the following code after your -RUN and comment out the HTMLFORM code which will create a report and validate the contents of the hold file. I will be surprised if the leading characters - + and ) are displayed.
TABLE FILE tmp PRINT LISTVALUE BY LOC_REGN_NUM ON TABLE PCHOLD FORMAT HTML END
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
June 19, 2018, 12:07 PM
tomatosauce
Contents of hold file seem to be without the special characters. They just show up when i try to do !IBI.FIL.TMP