Re: SQL views missing after Cumulative PTF's applied

[Robert Clay <zreclay@xxxxxxxxx>]

Nope.  We use a 10-character or less naming convention.  Here's an 
example of the SQL to build one (with "mylib" replacing the actual 
schema name):

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 ) ;

Robert

"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 11:22 AM, rob@xxxxxxxxx wrote:
> <snip>
> I think that it is strange that the views show up in SYSTABLES and yet
> don't really exist as objects.
> </snip>
> Possible that the view name and the system view name differ?  Like
> create view MyViewWithTheBigHonkingName ...
>
>
> Rob Berendt