ADD_CUS_OBJECTΒΆ

Add new Custom Object Definition.

Table: DBIADM.ADM_CUS_OBJECTS (SQL to populate specific tables or views from custom data sources. This object contains information about these tables and views for the local schema.)

Parameter Name

Properties

Default Value

Parameter Description

p_object_name

(PK)(NN)

Name of customer object

p_object_type

Type of customer object. Possible values: TABLE or VIEW.

p_object_sql_default

Placeholder SQL to create the object if the object is necessary for framework operation. Used if column OBJECT_SQL_CUSTOM is empty.

p_object_sql_custom

Customer specific SQL to create object

Example

EXECUTE SCRIPT api_dbiadm.add_cus_object
            ( 'XXX'      -- p_object_name
            , 'XXX'      -- p_object_type
            , 'XXX'      -- p_object_sql_default
            , 'XXX'      -- p_object_sql_custom
            );