Create a Table Descriptor
Use this API to create a Table Descriptor. Table Descriptors are owned by executable object definitions and Business Area definitions and are required to map to source and target Table instances. You must check out the parent object to create a Table Descriptor.
Name
CDR_PUB_DF_TABLE.CreateTableDescriptor
Signature
p_api_version IN NUMBER ,p_init_msg_list IN VARCHAR2 default CDR_PUB_DEF_CONSTANTS.G_FALSE ,p_commit IN VARCHAR2 default CDR_PUB_DEF_CONSTANTS.G_FALSE ,p_validation_level IN NUMBER default CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL ,x_return_status OUT NOCOPY VARCHAR2 ,x_msg_count OUT NOCOPY NUMBER ,x_msg_data OUT NOCOPY VARCHAR2 , pio_naming IN OUT NOCOPY cdr_naming_version_obj_type , pio_table_descriptor IN OUT NOCOPY cdr_table_desc_obj_type , pi_createType IN VARCHAR2 , pi_instanceSubTypeId IN NUMBER , pi_defClassificationColl IN CDR_CLASSIFICATIONS_COLL , pi_InstClassificationColl IN CDR_CLASSIFICATIONS_COLL ) ;
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- PIO_NAMING (Mandatory) This is a parameter of table type
CDR_NAMING_VERSION_OBJ_TYPE. Enter values to identify the Table Descriptor and
enter new values for the attributes you want to create. All attributes are
required. See CDR Naming Version Object Type. For OBJECT_TYPE_RC enter
$OBJTYPES$TABLEDESCRIPTOR
.If you are creating a Table Descriptor from an existing Table definition, enter values for the table definition in the CDR naming attributes. REF_COMPANY_ID, REF_OBJ_ID, REF_OBJ_VER.
If you are creating a new Table definition, leave these attributes blank.
- PIO_TABLE_DESCRIPTOR (Mandatory) This is a parameter of table type
CDR_TABLE_OBJ_TYPE that contains attributes specific to Table Descriptors,
including:
- LIBREF: Enter Target or Source.
- TARGET_OPER_FLAG_RC: Enter $YESNO$YES
- TARGET_AS_DATASET_FLAG_RC: Enter $YESNO$NO
- PROCESS_TYPE_RC: Enter $PROCESSTYPES$RELOAD
- REVEAL_AUDIT_FLAG_RC: Enter $YESNO$NO
- SEQ: Enter 1.
- PI_CREATETYPE (Mandatory)
- Enter INST to create a Table instance of an existing Table definition.
- Enter BOTH to create a Table definition and a Table instance of it.
- PI_INSTANCESUBTYPEID (Mandatory) Enter NULL.
- PI_DEFCLASSIFICATIONCOLL (Optional) To inherit its classifications for a
particular level from its parent, enter the classification level ID and, for the
CLASSIFICATION_ID, enter 0 (zero). The PAR_ attributes are not relevant. Do not
enter any values for them.
Or enter NULL.
- PI_INSTCLASSIFICATIONCOLL (Mandatory) Enter NULL because you are creating a Table definition.
Parent topic: Create and Modify Tables