CREATE FUNCTION DB2ADMIN.TEST1 (A BIGINT)
   RETURNS BIGINT
   DETERMINISTIC
   NO EXTERNAL ACTION
   RETURN select A from SYSIBM.SYSDUMMY1;

VALUES(DB2ADMIN.TEST1(3));

   CREATE FUNCTION DB2ADMIN.TEST1 (A BIGINT)
   RETURNS BIGINT
   AS TEMPLATE
   DETERMINISTIC
   NO EXTERNAL ACTION;

CREATE FUNCTION MAPPING TEST1_M
  FOR DB2ADMIN.TEST1(BIGINT)
  SERVER FDB;

VALUES(DB2ADMIN.TEST1(7));

  SQL0142N  The SQL statement is not supported.

CREATE NICKNAME DB2ADMIN.SYSDUMMY1 FOR FDB.SYSIBM.SYSDUMMY1;

SELECT DB2ADMIN.TEST1(35) FROM DB2ADMIN.SYSDUMMY1;