Troubleshooting
Problem
An expression in a model or report produces a character literal value which is a non-null string composed of zero characters ('').
Dynamic Query is aware of database vendors that do not follow the SQL standard and treat that value as being a null value.
For example, both ORACLE and Exasol document how their implementation does not follow the SQL standard.
When a zero length character literal is detected by Dynamic Query, it will result in query decomposition and more local processing.
Dynamic Query is aware of database vendors that do not follow the SQL standard and treat that value as being a null value.
For example, both ORACLE and Exasol document how their implementation does not follow the SQL standard.
When a zero length character literal is detected by Dynamic Query, it will result in query decomposition and more local processing.
Symptom
The following SQL statement defines a predicate which attempts to locate rows where the values in column C1 are a zero length string.
select C1 from MYTABLE where C1 = ''
When Dynamic Query detects that the underlying database does not follow the SQL standard, it will decompose the query and perform the comparison locally.
select C1 from MYTABLE where C1 = ''
When Dynamic Query detects that the underlying database does not follow the SQL standard, it will decompose the query and perform the comparison locally.
Document Location
Worldwide
[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl5uAAC","label":"Reporting-\u003EDynamic Query Mode and XQE"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
06 May 2025
UID
ibm16376256