If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

DQE UDF BNF

Started by DaHammer, 01 Oct 2020 08:38:17 PM

Previous topic - Next topic

DaHammer

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.   

DaHammer

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';