Help/Systems SEQUEL Software PowerTech
Home › Forums › Data Access and Analysis › SEQUEL

Sorting problem in a table (descending)

Submitted by jscote on Mon, 2010-01-04 15:28
in

I have a problem with the sort when I create a table.

The result of my view is sorted perfectly but when I execute the table, the sort (descending) is not working. I have multiple fields in the sort, and one is descending. However, it seems like descending is not working in the table. Is this a limitation of Sequel or it can be solve easely?

Thanks for your help.

‹ Email a Client Table through SEQUEL Script - Please Help ASAP Report saving into a member ›

Sort on a table

Submitted by richg on Thu, 2010-01-14 16:35.

When a Sequel table is created, the sort is automatically applied in ascending order to the dimension values. If you wish to control the sort order for a table result, the best solution is to export the results from the table to an iSeries database file, then create a view definition from the results of the table data. This method is also useful when you need to change the order of the categories (columns) created in the table application.

Login to post new content in forum or to comment on an existing forum post.

Need Help?

Talk to Us
In the U.S. and Canada, call 1-800-328-1000 and ask for Sales.
Elsewhere in the world, contact your local international office.