Troubleshooting
Problem
When opening an existing valid DB2 for z/OS SQL script in IBM Data Studio V3.1, the editor might show spurious syntax errors if the script contains a routine definition, including stored procedures, functions, or trigger definitions. The errors occur when the statement terminator for the script is set to semi-colon (;), and the body of the routine definition also contains statements separated by semi-colons.
Symptom
You receive syntax errors for a routine definition that contains valid SQL. For example, you receive syntax errors for scripts that you created in a previous release of Data Studio when you open them in Data Studio V3.1.
[{"Product":{"code":"SS62YD","label":"IBM Data Studio"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"SQL and XQuery Development","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"3.1","Edition":"IBM Data Studio","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:
16 June 2018
UID
swg21568227