Has anybody successfully implemented an ArrayType return value in a DQE UDF?
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.dg_dqe.doc/c_dg_dqe_bnf.html
I am having trouble understanding how RETURNS should be specified:
ArrayType ::= SimpleType <ARRAY_CONSTRUCTOR_START> IntegerValue ( <RBRACKET> | <RBRACKET_TRIGRAPH> )
No explanation given what ARRAY_CONSTRUCTOR_START is, not for the others.
Here is the syntax I received from IBM:
CREATE FUNCTION FINARRBINT ( p0 BIGINT ARRAY ??(5??) )
RETURNS BIGINT ARRAY ??(5??)
LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL NAME 'thisjar:udfs.FINARRBINT';