when I execute a query using the right function in the order by clause as below, select * from table order by right(col1,10) I am getting the following error.
SQL1585N A system temporary table space with sufficient page size does not exist.
The database has a temporary tablespace with 4KB as the page size. In the DB2 manuals to fix this prob it says remove the columns from the temporary table. Could any one tell what is to be done exactly to fix this.