Troubleshooting
Problem
You want to manually edit SQL in report builder queries to add columns. When you add columns, you want to use a special aggregate or other function such as the LAG or LEAD function. This feature is available in Db2 and Oracle, by using the appropriate syntax. But when you add the column you receive SQLParserException.
The feature to add columns is described in the IBM Documentation:
Manually editing SPARQL or SQL Report Builder queries
https://www.ibm.com/docs/en/elm/7.0.2?topic=builder-editing-sparql-sql-querie
Symptom
You receive an SQLParserException. For example,
CRRGW5628E An com.foundationdb.sql.parser.SQLParserException error occurred when validating the input SQL string,
caused by Encountered " "(" "( "" at line 4, column 21. Was expecting one of: <EOF> "except" ... "fetch" ... "for"
... "from" ... "group" ... "having" ... "intersect" ... "order" ... "union" ... "where" ... "window" ... "with"
... "offset" ... "limit" ... "," ... ";" ... 16:15:31Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTU9C","label":"Jazz Reporting Service"},"ARM Category":[{"code":"a8m0z000000CbNhAAK","label":"Jazz Reporting Service-\u003EReport Builder-\u003EDW DataSource Based-\u003EQuery SQL Customization(out of support scope)"}],"ARM Case Number":"TS010026927","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
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
More support for:
Jazz Reporting Service
Component:
Jazz Reporting Service->Report Builder->DW DataSource Based->Query SQL Customization(out of support scope)
Software version:
All Versions
Document number:
6606989
Modified date:
25 July 2022
UID
ibm16606989
Manage My Notification Subscriptions