DDL Difftable Table Creation Test

The script executes the `%mddl_dc_difftable` macro to generate the structure of a table named `WORK.DIFFTABLE`. It then uses the `%mp_assert` assertion macro combined with the `%mf_existds` macro function to validate that the table has been successfully created. Test results are stored in the `work.test_results` table.

Data Analysis

Type : CREATION_INTERNE

The 'DIFFTABLE' table is created by a Data Definition Language (DDL) macro and the results table is generated by the test macro.

1 Code Block

MACRO Data

Explanation :
Call of a DDL (Data Definition Language) macro to create the structure of the DIFFTABLE table in the temporary WORK library.

Copied!

1	%mddl_dc_difftable(libds=WORK.DIFFTABLE)

2 Code Block

MACRO Data

Explanation :
Execution of a unit test (assertion). The condition checks if the table exists via '%mf_existds'. If the table is missing, the test fails. The result is recorded in 'work.test_results'.

Copied!

1	%mp_assert(
2	iftrue=(%mf_existds(WORK.DIFFTABLE)=1),
3	desc=Checking TABLE was created,
4	outds=work.test_results
5	)

This material is provided "as is" by We Are Cas. There are no warranties, expressed or implied, as to merchantability or fitness for a particular purpose regarding the materials or code contained herein. We Are Cas is not responsible for errors in this material as it now exists or will exist, nor does We Are Cas provide technical support for it.

Retour à la liste