RunSCV macro at system level

The RunSCV macro is used to execute the specified job or program in Supply Chain Vault (SCV). This macro can pass optional parameter values to the SCV Job.

For executing the macro, the value in the Command field must be specified in this format:

RunSCV(Job, [Parameters])

Note: The optional parameters are specified in [ ].

This table lists the parameters that are used in the macro to determine the job to be created:

Parameter Name Description
Job The name of the job, or program to execute in SCV.
Parameters The parameters (0 to n) to be passed to the SCV job. The parameter list supports named parameters. For example, "-name=value." The name of the parameter and the value are linked to the corresponding parameter name in the SCV program.

This table lists the examples of the RunSCV macro:

Requirement Syntax

Run the SCV job "EXECUTE VALIDATION" (which executes various validations on SCV Inbox tables) to validate and transfer data to Core with application transformation. For example, execute SCV program EXECUTE_VALIDATION with these parameter values:

  • @p1: -TABLE_NAME = "" (All tables)
  • @p2: -TABLE_GROUP_NAME = "" (All table groups)
  • + @p3: -SOURCE = "" (All sources)
RunSCV("EXECUTE_VALIDATION","-TABLE_NAME=","-TABLE_GROUP_NAME=","-SOURCE=")

Run the SCV job "EXECUTE_TRANSFER" to transfer data from SCV Inbox to Core tables using an incremental refresh. The latest values from a configured date are only transferred. For example, execute SCV program EXECUTE_TRANSFER with these parameter values:

  • @p1: -REFRESH_MODE = Incremental
  • @p2: -TARGET_DELETE_MODE = Physical
  • @p3: -TARGET_UPDATE_MODE = Merge
  • @p4: -MAPPING_NAME = BASE_SI_SALES_HIST_AGGR-SC_SALES_HIST_AGGR_INCREMENTAL
RunSCV("EXECUTE_TRANSFER","-REFRESH_MODE=Incremental","-TARGET_DELETE_MODE=Physical","-TARGET_UPDATE_MODE=Merge","-MAPPING_NAME=BASE_SI_SALES_HIST_AGGR-SC_SALES_HIST_AGGR_INCREMENTAL")