Update, case, and -407

[MeBuggyYouJane]

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

[MeBuggyYouJane]

MeBuggyYouJane wrote:

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

Forgot: the win/xp machine has 8.2.9 ESE and the attendant ODBC driver,
I'm not in CubeLand, so don't have the version number.

[Serge Rielau]

MeBuggyYouJane wrote:

MeBuggyYouJane wrote:

>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

Forgot: the win/xp machine has 8.2.9 ESE and the attendant ODBC driver,
I'm not in CubeLand, so don't have the version number.

Keep in mind that there is an implied ELSE NULL in the CASE expression.
So the question is: Why do you hit the ELSE in DB2 for zOS and not on
DB2 for LUW.
Two choices:
* Different data
* Some difference in the WHERE clause you haven't shown us

My money is on the data. You got some 'bad' "OTHERFOO" on DB2 for zOS

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[MeBuggyYouJane]

Serge Rielau wrote:

MeBuggyYouJane wrote:

>MeBuggyYouJane wrote:

>>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

Forgot: the win/xp machine has 8.2.9 ESE and the attendant ODBC driver,
I'm not in CubeLand, so don't have the version number.

Keep in mind that there is an implied ELSE NULL in the CASE expression.
So the question is: Why do you hit the ELSE in DB2 for zOS and not on
DB2 for LUW.
Two choices:
* Different data
* Some difference in the WHERE clause you haven't shown us

My money is on the data. You got some 'bad' "OTHERFOO" on DB2 for zOS

Cheers
Serge

The moral of the story: don't trust COBOL/SPUFI coders. Either the
emulator or SPUFI has a "caps on" option, which re-writes quoted strings
too. So a

when otherFoo = 'SomeValue'

becomes

when otherFoo = 'SOMEVALUE'

and the -407 makes lots of sense.

:)

[Frank Swarbrick]

By default mainframe editors usually convert everything to uppercase...
(Not to say this is good. It's simply true.)

n 6/4/2008 at 5:35 PM, in message
<iu******************************@rcn.net>, MeBuggyYouJane<gn*****@rcn.com>
wrote:

Serge Rielau wrote:

>MeBuggyYouJane wrote:

>>MeBuggyYouJane wrote:
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

Forgot: the win/xp machine has 8.2.9 ESE and the attendant ODBC

driver,

>>I'm not in CubeLand, so don't have the version number.

Keep in mind that there is an implied ELSE NULL in the CASE expression.
So the question is: Why do you hit the ELSE in DB2 for zOS and not on
DB2 for LUW.
Two choices:
* Different data
* Some difference in the WHERE clause you haven't shown us

My money is on the data. You got some 'bad' "OTHERFOO" on DB2 for zOS

Cheers
Serge

The moral of the story: don't trust COBOL/SPUFI coders. Either the
emulator or SPUFI has a "caps on" option, which re-writes quoted strings
too. So a

when otherFoo = 'SomeValue'

becomes

when otherFoo = 'SOMEVALUE'

and the -407 makes lots of sense.

:)