SELECT VALUE (A.COL1,B.COL1)

Elixir · Posted: Thu Mar 24, 2011 6:02 pm

Hi,

I am trying to use the value clause in DB2.

SELECT VALUE (A.COL1,B.COL1)
FROM TAB1 A, TAB2 B

The above query retruns all the values in A.COL1 and B.COL1.

Its not clear.

Can some one explain me.

GuyC · Posted: Thu Mar 24, 2011 7:27 pm

it should be perfectly clear if those smilies weren't so distracting.

Just read the manual.

dbzTHEdinosauer · Posted: Thu Mar 24, 2011 8:10 pm

1. you are only returning one column.

2. you are doing a join with out any where clause
so your result it a cartisian (can't spell),
but the number of rows you return is a factor of
number of rows in tab1 X (times) number of rows in tab2.

unless you have any null values for a.col1, you are always returning
a unique a.col1. times the number of rows in tab2.

Phrzby Phil · Posted: Fri Mar 25, 2011 4:41 am

Dick - It's "cartesian."

I know you know it's named after Rene Descartes.

You also know he is known for "cogito, ergo sum" - "I think, therefore I am."

What you may not know, however, is that Descartes was out having lunch at the local sandwhich shoppe one day and ordered a hamburger. The waitress asked if he wanted fries with that, to which Descartes replied "I think not" - and he immediately disappeared.

Akatsukami · Posted: Fri Mar 25, 2011 4:03 pm

Elixir · Posted: Wed Apr 13, 2011 5:26 pm

Hi dbzTHEdinosauer,

I tried searching manuals to find description of VALUE clause, could not find it.

Please suggest if you know some manuals on it.

dbzTHEdinosauer · look under 3.2.13 COALESCE

look under 3.2.13 COALESCE