After too much (st,gr,f)umbling, here are v5.5.1 syntactical workarounds:
select...where...like '$1%' [valid syntax *until* v5.5.1]
can be replaced with:
select...where...like '$1'||'%'
or select...where...like concat('$1','%')
and
select...where...like upper('%
Jim -
I don't have a 5.5 to test, but I would try the construct:
... LIKE CONCAT($1, '%')
and see if that is accepted.
Richard Sims
On Jul 13, 2008, at 7:48 AM, James R Owen wrote:
After TSM v5.5.1 upgrade, the following command syntax is invalid:
select...where...like '$1%'
After TSM v5.5.1 upgrade, the following command syntax is invalid:
select...where...like '$1%'
This syntax was accepted in TSM scripts through TSM v5.5.0.3,
but our local scripts are broken after the upgrade.
Maybe I'm just too tired; is there a more appropriate technique to
concatenate $
