I was able to restore the object and rebuild the view. Thanks for the advice.
Will upgrading from 6.1 to 7.2 replace any other missing objects?
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Wednesday, September 21, 2016 12:42 PM
To: midrange-l@xxxxxxxxxxxx
Subject: [EXTERNAL] Re: Missing SYSIBM.SYSDUMMY1 object
On 21-Sep-2016 10:55 -0600, Rob Berendt wrote:
I would think a restore is entirely feasible. Another option is to
use iNav and retrieve the SQL source used to create that table.
Another option is to stop using it. Most uses revolved around stuff
like this:
select current time from sysibm.sysdummy1
These can often be replaced with the VALUES or the VALUES INTO
statement
values current time
A distinction with a difference.?:
I expect more appropriate is to suggest that SELECT would be replaced
with the use of a VALUES-clause [aka the _row-values clause\expression_
or values-row] in the query that defines the VIEW. That clause can
generate a derived-table [of one or more rows], in place of a SELECT
that might otherwise be composed to utilize the SYSDUMMY1 in SYSIBM [or
my preference, use the physical table QSQPTABL in QSYS2]. That is to
suggest, the VALUES _statement_ and VALUES INTO _statement_ are
something entirely different, despite the former looking quite similar
syntactically, neither of which can be referenced directly within a VIEW.
--
Regards, Chuck
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DQICAg&c=3crv0V5Gxwbo5hXTsiQI6g&r=PkbfvkKxtcDeNvEOH5BjJL4QM0EQmj0cLL71lzl405I&m=vPYGc0BgzrcFeCpRW0QeimCM4wD4BXLsFhA2LhR92UU&s=y56AHrPso7wJBDhemmUJhzTO00vaQK_RTTEvaRjzkwc&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://urldefense.proofpoint.com/v2/url?u=http-3A__archive.midrange.com_midrange-2Dl&d=DQICAg&c=3crv0V5Gxwbo5hXTsiQI6g&r=PkbfvkKxtcDeNvEOH5BjJL4QM0EQmj0cLL71lzl405I&m=vPYGc0BgzrcFeCpRW0QeimCM4wD4BXLsFhA2LhR92UU&s=SXaznuxqo8i7XcGoX7l0DqqJrbYO8aJTJbaLn_FYq-8&e= .
Please contact support@xxxxxxxxxxxx for any subscription related questions.
________________________________
Notice from Bob Evans Farms: This e-mail message, including any attachments, may contain confidential information that is intended only for the person or entity to which it is addressed. Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message and any attachments.
midrange.com
