Marc Lehnert wrote > 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?
You have to reduce the amount of output column and/or order columns. To sort the result SAP DB prefix the result record with the order columns and the internal width of these columns have to be smaller than 8096 bytes. Hope that helps. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
