Re: SACEGO PROBLEM

In article <1993Feb17.191515.2892@netcom.com> bobb@netcom.com (Bob Beaulieu) writes: >I have this sacego report for which I would like to run a select based upon the >value in the 9th position of a char(9) field. > >Let say the value in the field is "B0826.00A" > ^ this is what I want to select. You can write a shell wrapper to convert the "A" to "????????A", then pass that value as a parameter to the Ace report (e.g. sacego rptname "$shellvar"), and define input_var as a parameter within the report. Then, just do: select col_1,col2,col_3 from table_1 where col_1 matches "$input_var" >We have Informix Tech Support and their response is, "Informix can't handle it, >because of the 'matches' statement doesn't allow input variables". Hmmm. Completely wrong. Page 5-38R gives a specific example of matches with an input variable. >Thanks, >Bob Beaulieu >bob@netcom.com -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland Disclaimer: Poster under influence of 1,3,7-trimethylxanthine