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.
As always, please contact Broadcom support for CA Datacom if you have further questions.