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[
]
Resolving The Problem
This issue has been identified as a product defect and has been logged under APAR PK62050.
[{"Product":{"code":"SSRTLW","label":"Rational Application Developer for WebSphere Software"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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":"LOB45","label":"Automation"}},{"Product":{"code":"SSYK2S","label":"Rational Software Architect Designer"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
10 September 2020
UID
swg21297000