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

Products

• Datacom
• Datacom/DB
• Datacom/AD

Issue/Introduction

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?

Environment

Component : CA DATACOM SQL

Component : CA DATACOM/DB

Component : CA DATACOM/AD

Resolution

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.