469,602 Members | 1,961 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

Db2 on iSeries strange column names

Is this a bug in Db2 on iSeries V5 R3?

The following query should work:

CREATE TABLE qtemp.t03 AS (
SELECT 1 AS foofoo_s
, CASE WHEN 1=1 THEN 1 ELSE 2 END AS foofo
FROM sysibm.sysdummy1
) WITH data
;

but it responds with

Msg -153, Level 16, State S1000:
[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0153 - Column list
required.

However, with slightly different column names, e.g.:

CREATE TABLE qtemp.t03 AS (
SELECT 1 AS foofoo_s
, CASE WHEN 1=1 THEN 1 ELSE 2 END AS foof
FROM sysibm.sysdummy1
) WITH data
;

it works as expected.

Maks Romih

Dec 8 '06 #1
1 4626
maksr wrote:
Is this a bug in Db2 on iSeries V5 R3?

The following query should work:

CREATE TABLE qtemp.t03 AS (
SELECT 1 AS foofoo_s
, CASE WHEN 1=1 THEN 1 ELSE 2 END AS foofo
FROM sysibm.sysdummy1
) WITH data
;

but it responds with

Msg -153, Level 16, State S1000:
[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0153 - Column list
required.

However, with slightly different column names, e.g.:

CREATE TABLE qtemp.t03 AS (
SELECT 1 AS foofoo_s
, CASE WHEN 1=1 THEN 1 ELSE 2 END AS foof
FROM sysibm.sysdummy1
) WITH data
;

it works as expected.

Maks Romih
Yes it's a recently discovered bug. A PTF is in the works for V5R4.. if
you need one for V5R3 you should probably work with your IBM service
provider (the problem should only occur when the names are very similar).

--
Karl Hanson
Dec 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Jim Gerland | last post: by
1 post views Thread by Ben.Combrink | last post: by
3 posts views Thread by ah077 | last post: by
2 posts views Thread by --CELKO-- | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.