EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB18677: 'The function `CASE` is not supported in DBMS DB2 UDB V8.1/8.2 for Unix/Windows' error occurs when defining a column expression with a database specific function in Query Builder in MicroStrategy Developer 10.x.


Stefan Zepeda

Salesforce Solutions Architect • Strategy


In MicroStrategy Developer 10.x, the function `CASE` is not supported in DBMS DB2 UDB V8.1/8.2 for Unix/Windows' error occurs when defining a column expression with a database specific function in Query Builder.

SYMPTOM:
When defining a column expression in Query Builder with a Database Specific function such as with a 'CASE' statement, the following error is displayed when validating the expression in Strategy Developer 10.x:
 

ka02R000000kci7QAA_0EM440000002EiY.jpeg

The function `CASE` is not supported in DBMS DB2 UDB V8.1/8.2 for Unix/Windows
Note: This particular error message is only produced in the circumstance when a 'CASE' statement is used with a DB2 database.
 
CAUSE:
When using database-specific functions within query builder, users still need to use the Applysimple pass-through function in order to generate the correct SQL.
 
ACTION:
Utilize a pass-through function such as an ApplySimple, and include it in the definition of the column expression.
 


Comment

0 comments

Details

Knowledge Article

Published:

April 3, 2017

Last Updated:

April 3, 2017