Re: More fun with native RLA on an SQL view

[rob@xxxxxxxxx]

James,

RTM.  Throw away that last hard copy of the SQL reference you have from 
some ancient release.  Bookmanager is long dead also.  Start using the 
-CURRENT- infocenter.

You want a record format on a PF?  No problem, use the RCDFMT clause.
You want a key on a PF?  No problem, use the PRIMARY KEY clause.
Granted, I can see how those don't look anything like you would expect a 
record format or a key clause to look like, no, wait, I can't.

CREATE TABLE ROB/JAMES 
(RCDID CHAR (1 ) NOT NULL CHECK (RCDID IN('A','Z')),
MYKEY CHAR (5 ) NOT NULL, 
MYDATA CHAR (5 ) NOT NULL, 
PRIMARY KEY (MYKEY)) 
RCDFMT JAMESR 

Oh, you originally wanted a select/omit clause on a logical created with 
DDL to replace a DDS logical?  Use an index instead of a view.
CREATE INDEX ROB/JAMES01 ON ROB/JAMES
(MYDATA ASC) 
WHERE RCDID='A' 
RCDFMT JAMES01R ADD MYKEY, MYDATA

I believe PRIMARY KEY has been around since V3.
RCDFMT has been around for a few releases.
A WHERE clause on an index has been out for over two years.

If I came across as snippy attribute it to your opening statements 
sounding like you were baiting the bear.

HTH.

Rob Berendt