Before I do my usual thing and forget, we are on release V5r4
Why can't I add a primary key to a file in QTEMP?
The table is created no problem, however, for reasons TOO involved
I need to make the one field LCMPY into the primary key
When I run the following command in STRSQL
ALTER TABLE QTEMP/VACOMP add primary key (LCMPY)
I get the following error <ed: SQL7008>
VACOMP in QTEMP not valid for operation.
Using F1 on this error, the following is displayed
Message . . . . : VACOMP in QTEMP not valid for operation.
Cause . . . . . : The reason code is 10. Reason codes are:
rc10 -- A constraint or trigger is being added to an invalid type of
table, or the maximum number of triggers has been reached, or all
nodes of the distributed table are not at the same release level.
The file is NOT journalled
However, when I change everything so that the file is created in
another library, the add Primary key works