View previous topic :: View next topic
|
Author |
Message |
morpheus007
New User
Joined: 27 Dec 2005 Posts: 58
|
|
|
|
We have a requirement to Update a table only when an inner Select statement returns 1 row as result.If the select returns anything other than 1 row then the outer update must not run.
Kindly let me know how to code the query.The query has to be outside the programming environment as it will be run from jcl. |
|
Back to top |
|
|
stodolas
Active Member
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
|
|
|
|
Based on my experience, this is not possible. You need to check how many rows are returned from the SELECT before running the update. It needs to be done in 2 steps with a check between the 2 of them or the inner SELECT needs to have a scalar function or a FETCH FIRST 1 ROWS ONLY in it to force the get of only one row. |
|
Back to top |
|
|
|