Show TOC

New Model PropertiesLocate this document in the navigation structure

The propertyName parameter of the ra_add_prop command includes three new properties:
Table 1: Property Name and Description
Property Name Description
ddlCreateNewTable When the handleDDL property value is set to true, this property determines whether newly found tables on the primary database are added to the model and are set for materialization and replication.

Default: false

Valid values are true or false.
sequenceCacheSize The value used by SAP HANA sequences for the sequence cache:
  • If the property value is set to a positive value, the HANA sequence uses the value for the sequence cache. For example:
    CREATE SEQUENCE <name> CACHE <sequenceCacheSize>
  • If the property value is set to a negative or zero value, the HANA sequence is created without cache setting. For example:
    CREATE SEQUENCE <name>

Default: 0

Valid values are positive, negative, or zero.
keepBeforeStateInTriggers Determines whether the trigger records the before state of rows:

Default: true

If the property value is set to false, the trigger only records the after state of rows but not the before state. This can be a performance boost because the trigger has fewer rows to insert into the shadow table of the system.