CREATE FUNCTION DB2USER.GETPLACEHOLDER( MSG_TEMPLATE VARGRAPHIC(1000) )
    RETURNS TABLE
        (   IDCOL   INTEGER,
            COLNAME VARCHAR(1000)
        )
    SPECIFIC DB2USER.GETPLACEHOLDER
------------------------------------------------------------------------
-- SQL UDF (Table)
------------------------------------------------------------------------
F1: BEGIN ATOMIC

    --DECLARE NEWS_TEMPLATE VARCHAR(100);

    CREATE TABLE TEMP_TABLE
        (
            IDCOL INTEGER
            NOT NULL
                GENERATED ALWAYS AS IDENTITY
                (
                    START WITH +1
	    	    INCREMENT BY +1
	    	    MINVALUE +1
	    	    MAXVALUE +100
	    	    NO CYCLE
	    	    NO CACHE
                ),
            COLNAME VARCHAR(1000)
        );

    WHILE (LOCATE('$',MSG_TEMPLATE) != 0)
    DO
        --logic statements
    END WHILE;

    RETURN SELECT IDCOL, COLNAME FROM TEMP_TABLE;

    DELETE TABLE TEMP_TABLE;
    
END F1