SQL Editor shows syntax errors when the DDL statement terminator is set to semi-colon

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

More support for:
IBM Data Studio

Software version:
3.1

Operating system(s):
Linux, Windows

Document number:
460689

Modified date:
16 June 2018

UID

swg21568227

IBM Support

Tips