How to check Function Mapping with INFIX in system catalog view?

Question

I create a function mapping WITH INFIX:
CREATE FUNCTION SIMPLET1(timestamp, timestamp) RETURNS TIMESTAMP AS TEMPLATE NO EXTERNAL ACTION DETERMINISTIC;
CREATE FUNCTION MAPPING MAPSIMPLET1 FOR SIMPLET1(TIMESTAMP,timestamp) SERVER S3 OPTIONS (REMOTE_NAME 'SIMPLET1') WITH INFIX
;



How do I know the Function Mapping with INFIX or not in the system catalog view ? I check SYSCAT.FUNCMAPPARMOPTIONS,SYSCAT.FUNCMAPOPTIONS,SYSCAT.FUNCMAPPINGS, but I can not find any option is related to INFIX


Answer



INFIX is not explicitly shown as a option for function mapping in SYSCAT.FUNCMAPOPTIONS . But the remote name format will change. Let me show you a test how to verify this.

CREATE FUNCTION SIMPLET1(timestamp, timestamp) RETURNS TIMESTAMP AS TEMPLATE NO EXTERNAL ACTION DETERMINISTIC;
CREATE FUNCTION SIMPLET2(timestamp, timestamp) RETURNS TIMESTAMP AS TEMPLATE NO EXTERNAL ACTION DETERMINISTIC;
CREATE FUNCTION MAPPING MAPSIMPLET1 FOR SIMPLET1(TIMESTAMP,timestamp) SERVER S3 OPTIONS (REMOTE_NAME 'SIMPLET1') WITH INFIX
;
CREATE FUNCTION MAPPING MAPSIMPLET2 FOR SIMPLET2(TIMESTAMP,timestamp) SERVER S3 OPTIONS (REMOTE_NAME 'SIMPLET1');


db2 "select * from SYSCAT.FUNCMAPOPTIONS"

FUNCTION_MAPPING OPTION SETTING
------------------ -------------- --------------------
MAPSIMPLET1 REMOTE_NAME (:1P SIMPLET1 :2P)

MAPSIMPLET2 REMOTE_NAME SIMPLET1

Infocenter reference about INFIX:

https://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm...
WITH INFIX
Specifies that the data source function be generated in infix format.
The federated database system converts
prefix notation to the infix notation that is used by the remote data
source.