Pro/I Help - SQL tips

SQL Hack : Remove Attribute values

WARNING: Use these techniques and sample scripts at your own risk.
Always make sure you have a current and reliable BACKUP of the Intralink Commonspace before making any changes at SQL level.

You can create attributes with lists of allowable values.
The problem is - once you add a value, you can't remove it (see pic - Remove button is greyed out).

You can use SQL to remove an attribute value that is not currently used in the database.
The technique and sample script below originally came from PTC.

Note: It's recommended that all users log out of Intralink before you run this script.

Copy the script to your dataserver [Download sample script...]
Log on to the dataserver machine as an Administrator / Oracle Admin
Log in to SQLPLUS (sqlplus system/manager) and run the script with appropriate values:
```
@full_path_to_script\remove_attr.sql class attribute "value"
```
To ensure the changes take place, shutdown and restart the dataserver.

The potential values are:

Attribute Type	Class Name
Baseline Attributes	PDMc_Baseline
Branch Attributes	PDMc_PIBranch
Folder Attributes	PDMc_Folder
Object Attributes	PDMc_PI
Relationship Attributes	PDMc_Dependency
User Attributes	PDMc_User
User Group Attributes	PDMc_UserGroup

For example, say your script is in "c:\ptc\ilink\scripts"
and you want to remove "STEEL" from the object attribute Material:

@c:\ptc\ilink\scripts\remove_attr.sql PDMc_PI Material "STEEL"