Assertion with like

[angoca]

http://db2-sql-cookbook.org/#_sql_predicates 3.6.7

--#SET DELIMITER ! CREATE PROCEDURE LIKE_COLUMN ( IN instr1 VARCHAR(4000) , IN instr2 VARCHAR(4000) , OUT outval SMALLINT) LANGUAGE SQL CONTAINS SQL DETERMINISTIC NO EXTERNAL ACTION BEGIN SET outval = CASE WHEN instr1 LIKE instr2 THEN 1 ELSE 0 END; RETURN; END!