COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => SDK => Topic started by: DaHammer on 01 Oct 2020 08:38:17 PM

Title: DQE UDF BNF
Post by: DaHammer on 01 Oct 2020 08:38:17 PM
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.   
Title: Re: DQE UDF BNF
Post by: DaHammer on 06 Oct 2020 08:27:59 AM
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';