I have one problem in COBOL-DB2 -CICS program with LIKE in WHERE clause.This sql runs in SPUFI with hardcoded value but in program it is giving sqlcode +100.
The column in where clause is char(26) and has values like
'SCMTA 20070226093602001' .I want to ignore last 3 digit( i.e. 001) in sql. So value of WS-APLCN should be 'SCMTA 20070226093602%'. OR 'SCMTA 20070226093602&&&'
Please suggest .....
UPDATE mytable name
SET column-name = '99'
WHERE column name LIKE :WS-APLCN