KB47730: In MicroStrategy 9.4.x, the error "Illegal symbol [. Valid symbols are...." is received when executing a report against DB2 z/OS database when the table or column name contains special characters

SYMPTOM
The following error is received in Strategy 9.4.x when running a report against DB2 z/OS. 
 

[Database Classes][Error] Execute Query failed.
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [42000:-104: on SQLHANDLE] [Strategy][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]ILLEGAL SYMBOL [; VALID SYMBOLS ARE ( <IDENTIFIER> XMLTABLE TABLE FINAL OLD. For more information, please consult DB2 document for error code SQL0104. Connection String: ........ SQL Statement: select a11.YEAR_ID YEAR_ID from [DB$TEST].LY_YEAR a11

 
This issue is seen when running reports against any DB2 z/OS table that contains a special character such as a $ symbol in the table name, prefix name or column name. 
 
CAUSE
This is a known issue in Strategy version 9.4.x. In Strategy 9.4.x, the SQL engine incorrectly encloses table names/ column names /table prefix containing special characters with square brackets. SQL containing square brackets is not an acceptable SQL syntax for the DB2 z/OS database. In the above example, the special character $ is contained in the table prefix and hence is enclosed in square brackets by the Strategy 9.4.x SQL engine. 
 
 
ACTION
Contact Strategy Technical Support for an update on this issue.