Introduction

Available only for schemas created with AIP Core ≥ 8.3.45.

Properties on links can be either alphanumeric or numeric. To modify the property of a link that already exists in the Analysis schema, two CAST entry tables are used, depending on the type of property:

  • Alphanumeric > CI_STR_LINK_PROPERTIES
  • Numeric > CI_INT_LINK_PROPERTIES

The examples in this section modify numeric properties, however it is fairly simple to modify the queries if you want to work with alphanumeric properties. To view a list of properties that can be modified, use the CAST System View "CTV_PROPERTIES":

SELECT * FROM <local>.ctv_properties
ORDER BY <local.ctv_properties.prop_name

For example:

Adding a new/changing an existing property based on an OBJECT_ID

In this example, we are going to add a new numeric property as follows:

  • Line number where the first column of a composite index is not used in a WHERE clause, which is described in the Analysis Service as "nouseoffirstcolofcompidx_table_clientlanguage" and we are going to add the value "L_propertyValue".

The next step is to insert the data into the CAST entry tables that will cause the properties in question to be modified when the tool is run:

insert into <local>.CI_INT_LINK_PROPERTIES (CALLER_GUID, CALLED_GUID, PROP_NAME, VALUE, ERROR_ID) 
values ('methodCaller', 'methodCalled', 'nouseoffirstcolofcompidx_table_clientlanguage', L_propertyValue, 0);

The 0 parameter will enter 0 in the ERROR_ID column of the tables in question.

Removing an existing property based on an OBJECT_ID

In this example we are going to remove the numeric property we added in the previous example:

insert into <local>.CI_NO_LINK_PROPERTIES (CALLER_GUID, CALLED_GUID, PROP_NAME, ERROR_ID)
values ('methodCaller', 'methodCalled', 'nouseoffirstcolofcompidx_table_clientlanguage', 0);

The 0 parameter will enter 0 in the ERROR_ID column of the tables in question.