Yes, I did, and Daniela Danev was able to assist me. Interesting syntax, used at one point by C++ as well. Thanks for sharing here.
------------------------------
Dariusz Danielewski
------------------------------
Original Message:
Sent: Mon October 05, 2020 10:32 PM
From: NIGEL CAMPBELL
Subject: Guidance for DQE UDF BNF
Believe you asked a similar question via support.
See
CREATE FUNCTION FINARRBINT ( p0 BIGINT ARRAY ??(5??) )
RETURNS BIGINT ARRAY ??(5??)
LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL NAME 'thisjar:udfs.FINARRBINT';
------------------------------
NIGEL CAMPBELL
Original Message:
Sent: Thu October 01, 2020 03:27 PM
From: Dariusz Danielewski
Subject: Guidance for DQE UDF BNF
I am trying to figure out the proper DDL to define a UDF which would return an array from SQL or JAVA. The documentation, https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.dg_dqe.doc/c_dg_dqe_bnf.html is not clear how an ArrayType should be defined:
ArrayType ::= SimpleType <ARRAY_CONSTRUCTOR_START> IntegerValue ( <RBRACKET> | <RBRACKET_TRIGRAPH> )
Has anyone been able to return say a String[] from JAVA as and ArrayType?
Darek
------------------------------
Dariusz Danielewski
------------------------------
#CognosAnalyticswithWatson