Re: DB2 SQL confusion

[rob@xxxxxxxxx]

values(10, 1, 10*10**01, 10*10**02-1) 
        ,(10, 1, 10*10**02, 10*10**05-1)
        ,(10, 1, 10*10**05, 10*10**08-1)
        ,(10, 1, 10*10**08, 10*10**11-1)

....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8..
       VALUES          VALUES                     VALUES  VALUES
           10               1    1.0000000000000000E+002 
9.9900000000000000E+002
           10               1    1.0000000000000000E+003 
9.9999900000000000E+005
           10               1    1.0000000000000000E+006 
9.9999999900000000E+008
           10               1    1.0000000000000000E+009 
9.9999999999900000E+011

It did not like this statement
values(10, 1, 10*10**01, 10*10**02-1) 
        ,values(10, 1, 10*10**02, 10*10**05-1)
        ,values(10, 1, 10*10**05, 10*10**08-1)
        ,values(10, 1, 10*10**08, 10*10**11-1)
Number of columns not consistent.             (SQL0421)

That message alludes to a UNION.

UNION's are not happy with different data types.

select 'ALPHA', 'BRAVO' FROM SYSIBM/SYSDUMMY1 
UNION ALL 
SELECT 49.5,CURRENT DATE FROM SYSIBM/SYSDUMMY1

Constant value  Constant value
     +++++        ++++++++++ 
     49.5         2009-05-12 



Rob Berendt