Hello!
I'm using sapdb with the orion ejb container. I have got to execute a
statement such as: "select * from table_a order by column_a, column_b,
column_c". I created an index on each of the three columns. Everytime the
EJB container tries to access the data with such a statement the following
exception is thrown:
---------
java.rmi.RemoteException: Database error: SAP DBTech SQL: [-2003] (at 8127)
Output columns too long;
nested exception is: com.sap.dbtech.jdbc.exceptions.DatabaseException:
SAP DBTech SQL: [-2003] (at 8127) Output columns too long
----------
I don't know how to avoid sorting over the three columns. This error also
occurs when there are only about 1800 records in the table_a. Any ideas?
Thanks in advance,
Marc Lehnert.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
