SQL query ORDER by column not in SELECT for CA Datacom?


Article ID: 196099


Updated On:


CA Datacom CA Datacom/DB CA Datacom/AD CA Datacom/Server


When creating a query in SQL for CA Datacom, is it possible to have the results ordered by a column that is not in the SELECT clause?


Component : CA DATACOM SQL

Component : CA DATACOM/DB

Component : CA DATACOM/AD


At this time (in Version 15.1), it is not possible to have an ORDER BY clause use a column that is not in the SELECT clause. In application programs or by using other utilities, it is possible to manipulate a result set that includes the ordered column within the SELECT, but it cannot be done directly using SQL code.

Additional Information

As always, please contact Broadcom support for CA Datacom if you have further questions.