Troubleshooting
Problem
When using an alias in a []SELECT[] statment on Oracle® database
for example,
[]
SELECT a.column from table as a
[]
the outcome is:
[]java.sql.SQLException: ORA-00933: SQL command not properly ended[]
and in the editor the []SELECT[] statment becomes:
[]SELECT column from table as a[]
[{"Product":{"code":"SSRTLW","label":"Rational Application Developer for WebSphere Software"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Data Access Applications","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.0;7.0.0.1;7.0.0.2;7.0.0.3;7.0.0.4;7.0.0.5","Edition":"All Editions","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSYK2S","label":"Rational Software Architect Designer"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Data Access Applications","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.0;7.0.0.1;7.0.0.2;7.0.0.3;7.0.0.4;7.0.0.5","Edition":"All Editions","Line of Business":{"code":"LOB77","label":"Automation 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:
Rational Application Developer for WebSphere Software
Software version:
7.0, 7.0.0.1, 7.0.0.2, 7.0.0.3, 7.0.0.4, 7.0.0.5
Operating system(s):
Windows
Document number:
96405
Modified date:
10 September 2020
UID
swg21297000
Manage My Notification Subscriptions