Code Block Load - Full and Incremental Load Instructions

When the full load transformation logic is separate from subsequent loads, the dataset definition has separate instructions for each load type.

Note:

• You're required to enter the full Load block.
• Without an Incremental Load block, the dataset stops refreshing after the full load.
• The VIEW or INLINE table types don't support code_block_load.

Syntax:

code_block_load ::= ON FULL LOAD  
                    rowsource_specification
                    [column_mapping_assignment]... 
                    [ INCREMENTAL LOAD
                     rowsource_specification
                     [column_mapping_assignment]...
                    ]
                    ENDLOAD
                    [ default_row_specification ]
                    [ aggregate_specification ]
                    [ primary_key_specification ]
                    [ entity_id_specification ]
                    [ incremental_refresh_directive ]
                    [ delete_specification ]...

Example:

IMPORT SOURCE CUSTOMERS
DEFINE DATASET CUSTOMERS_D_FULL
    ON FULL LOAD
        ROWSOURCE CUSTOMERS WHERE CUSTOMERS.CUST_VALID = 'A';
    INCREMENTAL LOAD
        ROWSOURCE CUSTOMERS;
    ENDLOAD
END