Re: More fun with native RLA on an SQL view

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