Does JBEDS 5.1 support a subquery in criteria of an Update or Delete statement?

Solution Verified - Updated -

Issue

  • I've read that subqueries may not be supported in updates or deletes with JBEDS 5.1, and I'm looking to see when that applies or if there are any recommended workarounds.
  • Here is the simple query I'm using to test this which throws a left/right expression type error:

    update Draft 
    set Draft.DrftRecStatus='PendingSettlement' 
    where Draft.Id in (select Id from DraftDetail where drftrecid='B')
    
  • When I change the where statement to not use a subquery it works fine:

    where Draft.Id in ('820001','820002','820003','820004')
    

Environment

  • JBoss Enterprise Data Services (JBEDS) 5.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.