× 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

rob@xxxxxxxxx wrote:
Charles explained sysdummy1 pretty good. Often used in
STRSQL to test certain functions like:
select current_date from sysibm/sysdummy1

Now, it's been deprecated by the VALUES statement.
VALUES CURRENT_DATE
....+....1
VALUES 2009-05-12

You can even do a VALUES CURRENT_DATE INTO :HostVar

Which may make more sense than a dummy read of a file (like sysibm/sysdummy1) to get a value. <<SNIP>>

A VALUES statement typed in a STRSQL statement input line, presents a report.? Wow. I did not know that. Does it work to generate a multiple row report for multiple VALUES separated by commas and a multiple column report with comma separated values enclosed in parenthesis? And handle type merging\promotion?

For examples:

a>
VALUES ('Row 1')
,VALUES ('Row 2')

b>
VALUES (rand(), current time)

c>
VALUES (rand(), current time)
,VALUES (rand(), 'Just a string')

Regards, Chuck

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
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.