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