Delete statement - SQL Studio

[Michael MacIntyre]

Hello,
I have a table I recently populated with data - via jdbc from another datasource (it seemed easier than using repmcli). The problem seems to be when I wish to delete all of the rows. I issue the simple command delete from table (wishing to discard all of the rows I inserted). I let it run for about 4 hrs, with still no result. I thought pehaps some of the rows may have been locked (although I can delete a single row without a problem), so I took it off line then back on again with dbManager. No luck. Now I am trying to delete via jdbc, bu tthe end result seems to be the same - this time I set AutoCommit() to TRUE. There are only 5500 rows in the table...
any ideas?
Thank you in advance.
Michael MacIntyre

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general