dBforums - View Single Post

Lenny77 · #14 (**permalink**) 07-07-09, 16:12

Quote:

Originally Posted by Peter.Vanroose

DB2 v8 for z/OS does not support the "VALUES" statement, and has no BIGINT; try the following equivalent SQL instead:

Code:

WITH
n(n) AS (
 SELECT 2 FROM sysibm.sysdummy1 UNION ALL
 SELECT 3 FROM sysibm.sysdummy1 UNION ALL
 SELECT 5 FROM sysibm.sysdummy1 UNION ALL
 SELECT 7 FROM sysibm.sysdummy1 UNION ALL
 SELECT 13 FROM sysibm.sysdummy1 UNION ALL
 SELECT 17 FROM sysibm.sysdummy1 UNION ALL
 SELECT 19 FROM sysibm.sysdummy1 UNION ALL
 SELECT 31 FROM sysibm.sysdummy1 UNION ALL
 SELECT 61 FROM sysibm.sysdummy1 UNION ALL
 SELECT 89 FROM sysibm.sysdummy1 UNION ALL
 SELECT 107 FROM sysibm.sysdummy1 UNION ALL
 SELECT 127 FROM sysibm.sysdummy1 UNION ALL
 SELECT 521 FROM sysibm.sysdummy1 UNION ALL
 SELECT 609 FROM sysibm.sysdummy1 UNION ALL
 SELECT 1279 FROM sysibm.sysdummy1 UNION ALL
 SELECT 2203 FROM sysibm.sysdummy1 UNION ALL
 SELECT 2281 FROM sysibm.sysdummy1),
m(m) AS (SELECT POWER(2,n-1) FROM n)
SELECT m*(2*m-1) FROM m

This one will work. That's for sure. You can try any of my queries which I posted here. You will see how we can generate Prime and Perfect number without any constants.

Thanks, Lenny