× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. May 2009

Re: DB2 SQL confusion

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.