On Win XP SAP 7.4.3 Build 17, I'm getting an Invalid sequence for DML and DDL statements (-3007) when attempting a select from a given table. The error comes up via both JDBC and ODBC calls with any select from the problem table.
Documentation gives very little information on this error - it simply states "Repeat the QUERY and FETCH" which obviously does no good. The problem goes away by dropping and recreating the table, but that's not ideal by any stretch of the imagination.
Is this an error at the parse phase? ie if I flush the sql pool, might that help? Typically, when there's DB catalog corruption, I get an AK catalog error - but could this be the problem nonetheless?
Any insight would be appreciated.
I've experienced the same problem on linux with SapDB 7.4.3 Build 17. If i made selects on one table a got the same error message. If i modified the select so that i only get one result it works. SELECT * FROM sample_table where id > 0 fails with the error Invalid sequence for DML and DDL statements (-3007)
SELECT * FROM sample_table where id = 1 SELECT * FROM sample_table where id = 2 SELECT * FROM sample_table where id = 3 works.
I've written a little programm which creates a new table and copies all data from the "corrupt" table. The new table works, so the data seems to be ok. Even dropping the corrput table doesn't work.
Michael
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
