Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    1

    Unanswered: Db2 Locking for tables in subquery

    Hi,
    I'm asked to execute below query in CICS environement:

    Delete from A
    where A.COL1 IN
    ( SELECT B.COL2 FROM
    B INNER JOIN C ON COL2
    WHERE B.COL3 = C.COL3 )

    Please clarify if the DELETE causes locks on tables B and C
    in the subquery. If so at what level of data.

    Thanks,
    Kiran P.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Since this seems to be an exercise, how about giving us some details on what you came up yourself. We can then explain if this is right or not (and why not).
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •