Syntax

Insert

Nolog

• Should write log data into adm_module_log table? Presence of this node indicate that we should not write login to adm_module_log table.

TableName

• Name of the table to insert data to.

PrimaryKey

• List of primary key columns

Column

• Primary key column. Name: DB column name, value: name of the parameter to get value
• Multiple occurence

Column

• List of columns to insert data to

Column

• Column to insert data to. Name: DB column name, value: name of the parameter to get value
• Multiple occurence

DetailData

• List of detail tables to insert data to

DetailData

• Detail table to insert data to
• Multiple occurence

Validation

Unique

Example

Insert
    TableName==ADM_DATA_CLASS
    PrimaryKey
        DATA_CLASS_ID==pk
            Automatic==SEQ_ADM_DATA_CLASS.nextval
            Retrieve
    Column
        DATA_TYPE_ID==DATA_TYPE_ID
        NAME==NAME
        DESCRIPTION==DESCRIPTION
    DetailData
        ADM_DATA_CLASS_DETAIL==FK_ADCD_ADC_CORRECTED
            ForeignKey
                DATA_CLASS_ID==pk
            Column
                VALUE==0
        ADM_GROUP_DATA_CLASS==FK_AGDC_ADC_CORRECTED
            ForeignKey
                DATA_CLASS_ID==pk
            Column
                GROUP_ID==0
                RIGHT_CODE==1
                ACCESS_TYPE==2