Technote (troubleshooting)
Problem(Abstract)
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.
| Segment | Product | Component | Platform | Version | Edition |
|---|---|---|---|---|---|
| Software Development | Rational Software Architect | Data Access Applications | Windows | 7.0, 7.0.0.1, 7.0.0.2, 7.0.0.3, 7.0.0.4, 7.0.0.5 | All Editions |
Rate this page:
Average rating
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.