>I have trouble to create an index of ascending and descending.
>For example I create employee table below. I want Ename is ascending, Deptno is descending in table emp.
>
>CREATE TABLE employee ;
> (Empno c(10) UNIQUE, ;
> Ename c(10), ;
> Job c(3), ;
> Deptno c(30))
>
>please help this code out.
>
>Thanks,
>DT

Do you want this index to represent whole table in grid in sorder order?
What is DeptNo, integer stored as character?