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"}}]
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 the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. 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