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 am getting the output as follows

  
<option value="ALL" Selected>All</option>
-<option value="1">1-Northeast Region</option>
+<option value="2">2-Central Region</option>
)<option value="3">3-South Region</option>

Instead i should be getting something like this without the -,+,} symbols

  
<option value="ALL" Selected>All</option>
<option value="1">1-Northeast Region</option>
<option value="2">2-Central Region</option>
<option value="3">3-South Region</option>

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,

Tomatoesauce

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


Contents of hold file seem to be without the special characters. They just show up when i try to do !IBI.FIL.TMP

Guessing the format of LISTVALUE is variable, e.g,. AnV.

? HOLD TMP should confirm.

If it is variable, convert to fixed format. An.

Something like...

TABLE FILE SQLOUT
PRINT 
COMPUTE NEWVALUE/A1024 = LISTVALUE;
BY LOC_REGN_NUM NOPRINT
ON TABLE HOLD AS TMP
END

This message has been edited. Last edited by: David Briars,

David,

you are awesome. Changing it to fixed format did the trick.