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

Author Topic: DQE UDF BNF  (Read 1528 times)

Offline DaHammer

  • Full Member
  • ***
  • Join Date: Jun 2016
  • Posts: 19
  • Forum Citizenship: +0/-0
DQE UDF BNF
« 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.   

Offline DaHammer

  • Full Member
  • ***
  • Join Date: Jun 2016
  • Posts: 19
  • Forum Citizenship: +0/-0
Re: DQE UDF BNF
« Reply #1 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';