Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > Update, case, a...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 8939 of 9520
Post > Topic >>

Update, case, and -407

by MeBuggyYouJane <gnuoytr@[EMAIL PROTECTED] > Jun 3, 2008 at 10:35 PM

The following (skeleton) works fine when using AQT (win/xp, ODBC),
but throws a -407 when issued from green screen SPUFI.  The DB is 8.1.5
on z/OS.

update tableFoo
set colFoo =
case
    when otherFoo = 'A' then 'B'
    when otherFoo = 'C' then 'D'
end

Any notion why?  Couldn't find an APAR or any explanation on
the DB2 site.

thx
 




 5 Posts in Topic:
Update, case, and -407
MeBuggyYouJane <gnuoyt  2008-06-03 22:35:50 
Re: Update, case, and -407
MeBuggyYouJane <gnuoyt  2008-06-03 22:39:56 
Re: Update, case, and -407
Serge Rielau <srielau@  2008-06-04 01:55:13 
Re: Update, case, and -407
MeBuggyYouJane <gnuoyt  2008-06-04 19:35:50 
Re: Update, case, and -407
"Frank Swarbrick&quo  2008-06-04 18:35:46 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 20:27:53 CST 2008.