How it works…

The first two subroutines, named SUB Create_T_Product and SUB Create_T_Customer, create the tables called Product and Customer, and then store the data in these tables.

The third subroutine, SUB Create_QVD_Standard(vTable,vSub), passes the values of the respective table names and the subroutines. Within this subroutine, we also create a number of fields using the load script functions, which are used for our QVD audit purposes.

Further, the CALL statements call the subroutines and create QVDs to store them in specified folders.

Along with creating and storing the QVDs, we also get valuable information, such as the number of fields in each QVD, the time it takes to create the QVDs, and so on. This is especially helpful while loading a large dataset.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset