My cloudscape database is perhaps corrupted.I download some fixes and one th
em needs the following query to be executed.

Execute the statement
UPDATE @DbUser@.COMP_INST AS a SET a.SHADOW_OID = (SELECT b.SHADOW_OID FROM 
@DbUser@.COMP_INST AS b WHERE b.OID = a.SHADOW_OID) WHERE a.SHADOW_OID IN (S
ELECT c.OID FROM @DbUser@.COMP_INST AS c WHERE c.SHADOW_OID IS NOT NULL)
as long as the next select statement returns a value greater than 0:
SELECT COUNT(a.OID) FROM @DbUser@.COMP_INST AS a, @DbUser@.COMP_INST AS b WH
ERE a.SHADOW_OID IS NOT NULL AND a.OID = b.SHADOW_OID

2. Execute this statement:
DELETE FROM @DbUser@.COMP_INST AS a WHERE a.SHADOW_OID IS NOT NULL AND a.OID
 < (SELECT MAX(b.OID) FROM @DbUser@.COMP_INST AS b WHERE b.SHADOW_OID = a.SH
ADOW_OID)

Problem is these queries are not getting executed giving a funny error "As" 
encountered which is definately a valid sql syntax.

My questions are two. In respect to the above query how do i solve it?
Secondly is there anyother cloudscape script which can get my WPS configurat
ion to its original state?

[ Post a follow-up to this message ]

Running the command with @DBUser@... will not work.  See this technote for instructions
....  http://www-1.ibm.com/support/docvie...uid=swg21221049

[ Post a follow-up to this message ]