CA IDMS Tuesday Tip by Edward Gorga, Principal Support Engineer for April 2, 2013.
You may sometimes find when trying to change or delete a record in IDD that it is not 'owned' by IDD so it cannot be deleted or changed. You may get error DC601045 or DC601046 NOT IDD OWNED.
'Not owned' means it is associated with another entity, like a map or a dialog. Normally a display of the record will show you what component it is associated with but in some cases it is not associated with anything else but is not owned by IDD. The owning entity is contained in the builder code for the record.
You can use the following SQL statement to list the builder code for a record:
SELECT SR_NAM_036, RCD_VERS_036, BUILDER_036
FROM APPLDICT."SR-036"
WHERE SR_NAM_036='recordname' AND RCD_VER_036=1;
You could also display all of the record versions:
SELECT SR_NAM_036, RCD_VERS_036, BUILDER_036
FROM APPLDICT."SR-036"
WHERE SR_NAM_036='recordname';
If you don't have a SQL schema defined for your dictionary (in this case APPLDICT) do this first:
CREATE SCHEMA APPLDICT
FOR NONSQL SCHEMA SYSDIRL.IDMSNTWK VERSION 1
DBNAME APPLDICT;
;
Here is a list of the builder codes and the associated component:
C CA IDMS mapping compilers
D IDD DDDL compiler
G CA IDMS sysgen compiler (source records)
R CA IDMS sysgen compiler (object records)
S Schema compiler
V Subschema compiler
M DML processors
A CA ADS dialog compiler
P CA ADS application generator
X CA IDMSDIRL utility
If you find a record that is not associated with any other component but has an incorrect builder code use the following SQL statement to update the builder code to 'D' and make it IDD owned:
UPDATE APPLDICT."SR-036"
SET BUILDER_036='D'
WHERE SR_NAM_036='recordname'
AND RCD_VERS_036=1;