October 03, 2007, 10:24 AM
<Darron>Setting a Variable from a Database field DM 7.61
when trying to set a gloabal variable to a Varchar field from a SQL table using a hold table with the format ALPHA the resultant output is prefixed with the length of the DB field ie ALL returned from a Varchar(10) field will result in '000010ALL' being returned.
This is sorted out by using the DFIX format on the hold table with any particular delimiter
IE
ON TABLE HOLD AS HLD FORMAT DFIX DELIMITER TAB
This works , but takes hours to figure out if your not sure
October 03, 2007, 02:57 PM
GinnyJakesUse the SET VARCHAR OFF statement for your RDBMS. It will then not hold the data as a varchar.