DB2 functions in BO PRM file

building semantic layer
1

Hello,
we are using DB2 on MVS for our corporate Data Warehouse and BO for reporting. BO provides interface files in which database specific things are specified. Functions are stored in the PRM file.

In the DB2 PRM file some functions are stored, but it is not complete and there are errors in there. For example the substring function is wrong. Does anyone have a complete and correct PRM file for DB2?

Regards, Michiel Brunt
ABN AMRO Bank

(16)
NAME= Substring
TRAD= String: $Initial position: $Number of characters: HELP= Extracts a sequence of characters from a character string TYPE=A
IN_MACRO=Y
GROUP=N
SQL=SUBSTRing($A,$n,$n)

It should be:
SQL=SUBSTR($A, $n, $n)

Listserv Archives (BOB member since 2002-06-25)

2

Boundary=“0__=yHwQYvjkqllhLhUWda7xv2SAHF3wYpT5Fvd6d9kceSNFyEffhftSOBNn”

–0__=yHwQYvjkqllhLhUWda7xv2SAHF3wYpT5Fvd6d9kceSNFyEffhftSOBNn Content-type: text/plain; charset=US-ASCII

Michiel,

Try this one. (See attached file: Db2peen.prm)

DebraAnn Braun
Frito-Lay, Inc

Hello,
we are using DB2 on MVS for our corporate Data Warehouse and BO for reporting. BO provides interface files in which database specific things are specified. Functions are stored in the PRM file. In the DB2 PRM file some functions are stored, but it is not complete and there are errors in there. For example the substring function is wrong. Does anyone have a complete and correct PRM file for DB2? Regards, Michiel Brunt
ABN AMRO Bank

Listserv Archives (BOB member since 2002-06-25)