Move your mouse round the image for details.

This Meta-Update sample can be used after a VM clone or a Database Refresh.

[Main] declares script arguments and usage.

[Main]'s AssignInit decides which section will be Launched based on the arguments given. It also initializes a few script variables. It throws an error if needed.

[Do] then Launches only one of its sections for: -bkp, -rst, -del, and -chg.

Each of these perform the different functions of the script.

Move your mouse round the image for details.

All Meta-Update Sample Scripts have plenty of comments. Please feel free to take a copy and edit. Use the debugger to single-step through the scripts.

[Main] describes arguments, sets up server connections, has initial and terminating assignments, and gives usage information.

Here, we have one required argument so that we can allow the user to specify the input using different optional arguments:

-go		Required to avoid help — all others are optional
-bkp		Specifies a CSV file prefix to backup some forms before the database replication.
-rst		Specifies the same file prefix to restore forms.
-del		Ad-hoc delete of records in Email and Notification forms
-chg		Change one or all required Remedy Server references. Run twice for different midtier servers.

Move your mouse down for AssignInit details.

[Main]'s AssignInit serves three functions

• Initializes script variables (in tag V) to control which sections get launched on a -chg when a -only is used.
• Checks that arguments are not used mutually exclusively and that required arguments for various options are entered, Aborting if not.
• Sets the -chg section variables if the form exists using a LookUp assignment.

At the end of a sequence of ifs, it checks if $V, ErrMux$ is set and issues an Abort to stop the job if so.

If none of the -bkp, -rst, or -del arguments are used, we continue at the else and we have a -chg by default.

Here we check required arguments are set and Abort if not.

We also set the Launch switches further by ensuring each sections form exists using a LookUp assignment.

Scroll down to the else for more details.

Move your mouse round the image for details.

We also check that each Query= form exists and turn off that form's section's Launch= variable if not.

The LookUp, [Lkp-FormExists] references the passed form name with $CTL, LookUp_Src$.

It uses that in a QuerySql that returns an integer into the assigned variable.

Continue by clicking on page 2 for details on [Do] and the rest of the script.