Re: SQL views missing after Cumulative PTF's applied

[Robert Clay <zreclay@xxxxxxxxx>]

V6.1.0 LPAR

And...viola!  Give that man a prize.

Object . . . . . . . :   SYSDUMMY1       Attribute  . . . . . : PF
  Library  . . . . . :     SYSIBM        Owner  . . . . . . . : QSYS
Library ASP device . :   *SYSBAS         Library ASP group  . : *SYSBAS
Type . . . . . . . . :   *FILE           Primary group  . . . : *NONE
Creation information:
  Creation date/time . . . . . . . . . :   08/26/13 00:01:01
  Created by user  . . . . . . . . . . : QSYS
  System created on  . . . . . . . . . : S101F63M
  Object domain  . . . . . . . . . . . : *SYSTEM

So, syntactically, how would I make the change to using the VALUES 
clause with a UNION ALL?

CREATE VIEW mylib.companyv1 AS (
SELECT 0 AS compid, 'Unknown/unmaintained' AS compdesc FROM 
sysibm.sysdummy1
UNION ALL
SELECT cocoid AS compid, codesc AS compdesc FROM mylib.company ) ;

Everything that I've tried comes up with errors.


"Contrariwise, if it was so, it might be; and if it were so, it would 
be; but as it isn't, it ain't. That's logic."--Tweedledee
On 08/26/2013 1:14 PM, rob@xxxxxxxxx wrote:
> Ok, I know we were told "don't ask" so I won't.  Instead, I'll assume.
> Much of the use for SYSDUMMY1 has vanished.  I would suspect it's only
> there for compatibility reasons.  There are two different statements which
> should be able to replace most, if not all, of the use of SYSDUMMY1.  They
> are SET and VALUES.
>
> For example, I can replace:
> select days('2013-09-30') - days(current date) from sysibm.sysdummy1
> with
> values days('2013-09-30') - days(current date)
> Either will tell me the number of days until V5R4 expires - 55.  I will
> turn 52 when it is 52 days until V5R4 expires.  (Guess that means I'll
> finally be playing with a full deck.)
>
> Perhaps, based on Charles statement, if you can replace your usage of
> sysdummy1 your issues may go away.
>
> Guess when I put my last cume on?
> Object . . . . . . . :   SYSDUMMY1
>    Library  . . . . . :     SYSIBM
> Library ASP device . :   *SYSBAS
> Type . . . . . . . . :   *FILE
> Creation information:
>    Creation date/time . . . . . . . . . :   06/08/13  08:00:20
>    Created by user  . . . . . . . . . . :   QSYS
>
>
>
> Rob Berendt