1.75 Maintain Dynamic Package - DML Execution

This topic explains systematic instructions to maintain a dynamic package DML execution.

Through the Dynamic Package - DML Execution screen, synchronize the dynamic packages and DML statements which have to get propagated to the PDBs from Approot.

Note:

The fields which are marked in asterisk are mandatory.

1. On Homescreen, type CODDYNCL in the text box, and click Next.
   The Dynamic Package - DML Execution screen displays.

   Figure 1-82 Dynamic Package - DML Execution

   
   

   
   Description of "Figure 1-82 Dynamic Package - DML Execution"

   
   
2. On the Dynamic Package - DML Execution screen, specify the fields.

   For more information on fields, refer to the field description table.

   Table 1-98 Dynamic Package - DML Execution - Field Description

   Field	Description
   Module Code	Click Search and specify the module code for which the dynamic packages and DML statements have to get propagated to the PDB from Approot. The list of values displays all valid module codes maintained in the system.
   Function ID	The system displays the function ID based on the Module Code selected.
   Status	Select any of the following options: Unprocessed- Select this option to fetch the unprocessed records in the PDB and proceed with processing. Processed - Select this option to view the recent synchronized records in PDB. The status column depicts the processed status of the records.
   Populate	After selecting status , click Populate to fetch the list of records to be processed or records that are already processed based.

   On selecting the Status as Unprocessed and upon clicking Populate, the list of records that are yet to be compiled in the PDB displays.
3. Click Process All Records to process unprocessed records.
   The system displays an information message once the processing of all the records is completed. It is not allowed to do any other operation after processing the records. The action icons will be disabled.
4. Click Error Details to view error records.
   The Error Details screen displays.

   Figure 1-83 Error Details

   
   

   
   Description of "Figure 1-83 Error Details"

   
   

   This screen displays error records along with the following criteria:

   • Module Code
   • Function Id
   • Function Type
   • Function Param
   • Version Number
   • Error
5. Click Exit to end the transaction.