DIC insert process
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
- Detail table to insert data to
- Multiple occurence
Validation
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