Unanswered: Confused - Select and Insert work - Delete and Update "Too Complex???"
I am running DB2 UDB V7 on NT.
I have recently started getting the following error on attempting to do deletes and updates on the tables -
DELETE FROM PMRA.WBS
WHERE(( PMRA.WBS.WBSID = 35 ));
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL0101N The statement is too long or too complex. SQLSTATE=54001
INSERT and SELECT works but not update and delete.
The tables are not in check pending state..I tried increasing the APP Heap size etc. - no improvement....