CREATE TABLE as sub-query with primary key syntax

["Peter Dow (ML)" <maillist@xxxxxxxxxxxxxxx>]

I'm trying to create a table with this by putting the following into a 
source member and using RUNSQLSTM:

CREATE TABLE TEMP AS (                        
 SELECT DBIFIL, DBIFMT, DBIFLD, DBIUPD          
   FROM QSYS/QADBIFLD                           
  WHERE DBIFIL = "TEST"
 PRIMARY KEY(DBIFIL, DBIFMT, DBIFLD)            
 WITH DATA;

It doesn't like the PRIMARY KEY() clause.  I checked the v5r3 SQL 
manual, and it doesn't give any examples of doing it, but has the 
following to say under the "as sub-query" heading of the CREATE TABLE 
command:

"The implicit definition does not include any other optional attributes 
of the identified table or view. For example, the new table does not 
automatically include a primary key or foreign key from a table. The new 
table has these and other optional attributes only if the optional 
clauses are explicitly specified."

which to me implies that I can use the PRIMARY KEY clause, I just don't 
have the syntax right.

Does anyone know the correct syntax, or whether this is allowed or not?

*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /