The Workload Automation Programming Language (WAPL) interface allows to easily manipulate Variable Tables through batch jobs.
In fact, it supplies a Batch Loader-like processor through which it is possible to CREATE and MANIPULATE variable tables inside IBM Workload Scheduler Database.
For example, through the following WAPL JCL:
You can create the MYVARTAB table in the database. Note that the BL-like statements can also be contained in a dataset.
You can create, update and replace a variable table using respectively the CREATE, UPDATE and REPLACE option in the DBMODE parameter.
But the most interesting capability is in the possibility to BACKUP a variable table, in order to recreate it later or in another WAz installation.
Using the following commands, in a WAPL JCL:
You obtain the following statements:
That, through another WAPL jcl, you can run to create the same table, or change to create a different one.
…and even backup all the tables is possible: