MODIFY_GPR_OBJECTSΒΆ

Modify specified GPR-Objects record.

Table: REDGPR.GPR_GPR_OBJECTS (This table maps GPR data table/view and its column, if there is no fix target value set for GPR)

Parameter Name

Properties

Default Value

Parameter Description

p_gpr_config_id

(PK)(NN)

Foreign key to the GPR_CONFIG table

p_gpr_obj_schema

(PK)(NN)

Name of the schema of the GPR data table/view

p_gpr_obj_name

(PK)(NN)

Name of the GPR data table/view

p_gpr_obj_column

(PK)(NN)

Name of the GRP column used in the GPR data table/view

p_gpr_where

Example

EXECUTE SCRIPT api_redgpr.modify_gpr_objects
            , 0          -- p_gpr_config_id
            , 'XXX'      -- p_gpr_obj_schema
            , 'XXX'      -- p_gpr_obj_name
            , 'XXX'      -- p_gpr_obj_column
            , 'XXX'      -- p_gpr_where
            );