Business scenarios often require running linked Query and Transaction scripts. Studio supports this script 'cross-linking,' enabling you to download and upload data (or upload and download data) in a single step.
To cross-link scripts, your scripts must be mapped to an Excel data source.
This feature is available in the following Studio modes and versions:
- Studio 20.3 with Evolve or Studio Manager and
- Studio 20.3 and 12.1 with Connect
Details
To create cross-linked scripts, go to the Chain Run Settings panel. Chain script information is here.
You can cross-link one or more Query scripts with one or more Transaction scripts, and there is no limit to the number of scripts you can cross-link.
You can cross-link one or more Query scripts with one or more Transaction scripts, and there is no limit to the number of scripts you can cross-link. Studio 20.1 supports cross-linking of Query and Transaction scripts in the same chain for standard workflow (NDR) and only if Query is the first script ("base script"); the only supported chain setting is “All from individual script”.
Notes: If you want to schedule a cross-linked script, the first script in the chain must be a Transaction script. (The first script in a chain is called the "base" script.) The scheduling behavior will be the same as a Transaction-only script (and this is applicable to Studio Manager as well).
Simulate, Validate, and Debug options work only on Transaction scripts, and only when the Transaction script is the first script in a chain of cross-linked scripts. The Simulate, Validate and Debug options stop working once a Query script is encountered in the chain of cross-linked scripts.
Cross-linked scripts support the following:
- Schedule Run
- Command Line Run
- Macro Run
They also support the All from individual ALC setting for both Studio and the Add-in. Find information on the All from individual setting here.
The System-generated File Name option is shown for cross-linked script chains only if Query scripts is the base script in the chain sequence.
Cross-linked scripts - working from the Add-in
When opening published child scripts from the Add-in, the icon, details, and script run settings will be the same as those of the parent script.
From the Add-in, you can Schedule Run cross-linked scripts.
Run Options for Cross-linked Scripts
The Run Option from a Transaction script is Run Specified Range (Row __ to __), as in the screenshot below.
The Run Option from a Query script is Run Script and Retrieve __ Records, as in the screenshot below.