123456789101112131415161718 |
- -- Licensed Materials - Property of IBM
- --
- -- BI and PM: CM
- --
- -- (C) Copyright IBM Corp. 2008, 2009
- --
- -- US Government Users Restricted Rights - Use, duplication or disclosure
- -- restricted by GSA ADP Schedule Contract with IBM Corp.
- -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
- -- Cognos (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).
- insert into CMREFORD1 (PROPID, CMID, ORD, REFCMID)
- select 27, (select cmid from cmobjprops1 where objid='::System Administrators'),
- coalesce((select max(ord) from CMREFORD1 where propid=27 and cmid=(select cmid from cmobjprops1 where objid='::System Administrators')), -1)+1,
- CMID
- from CMOBJPROPS1 where OBJID='::Everyone'
|