CREATE PROCEDURE GUS_ADM.DELETEATTRIBUTE (
  IN vAT_ID BIGINT,
  IN vDELETED_BY BIGINT
)
BEGIN ATOMIC
    DECLARE v_dummy integer;

    WITH a(attribute_id) as (
        select attribute_id from attribute where attribute_id = vAT_ID and datetime_deleted is null 
        UNION ALL
        SELECT at.attribute_id from attribute at, a where at.parent_id=a.attribute_id and at.datetime_deleted is null 
    )
,update_mtm_attrib2person as
    (select  1  FROM NEW TABLE (update mtm_attrib2person set DATETIME_DELETED = CURRENT TIMESTAMP, DELETED_BY = vDELETED_BY where attribute_id in (SELECT attribute_id FROM a)))
SELECT  1  INTO dummy FROM sysibm.sysdummy1;

END
~

 DB2 SQL error: SQLCODE: - 104 , SQLSTATE:  42601 , SQLERRMC: WITH;sysibm.sysdummy1;

;SELECT
 Message: An unexpected token "WITH" was found following "sysibm.sysdummy1".  Expected tokens may include:  "

".