Question & Answer
Question
Can you call an SQL function or a stored procedure from Advanced SQL in a data warehouse report in IBM Jazz Reporting Service (JRS)?
Cause
You have create an SQL function or a stored procedure in your data warehouse database. This function or procedure executes correctly when called from any database client. However, when used in Advanced SQL, the procedure appears to return no results. Reports that call the function from Advanced SQL fail to validate and report error CRRGW5628E, even if validation is turned off.
Answer
Using stored procedures and SQL functions in Advanced SQL is not supported.
[{"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":"TS020478718","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.0.6;7.0.0;7.0.1;7.0.2;7.0.3;7.1.0"}]
Was this topic helpful?
Document Information
Modified date:
29 January 2026
UID
ibm17249942