Download QUERY User Guide - Winshuttle Software

Winshuttle QUERY User Guide

If no data-review is required, you can run the data sheet for linked scripts from QUERY.
Validating linked scripts
Linked scripts intended for Excel output can be validated. Validation on linked scripts is possible
for the following configurations:

Column-based mapping and cell-based mapping in Excel forms.

Column-based files linked to cell-based files and vice versa.
If the second file uses cell-based mapping with loops, you are prompted to provide the name of
the log column before the second file runs.
Linked scripts with run time variables
You can link query scripts with multiple run time variables. While running the linked query scripts,
QUERY prompts you to enter run time variables for each of the linked script file.
The Run time variable wizard displays the fields to enter values of variables. You can type in the
values manually or fetch the values from SAP using the browse button
.
Note: Linked query script files must be in production status before they can be scheduled for
running.
Result file options (not available for Winshuttle SERVER)
Save and close output file after run: Click to save the contents of the data file and close it
after a data download.
Warn if data is present on result file: Click to be warned if there is already contents in the
output file. You are given the options to save as a new file, Cancel, or write to the file. Writing to
the file presents three more options, which you can also set in the Data writing options.
Write header information on result file: Not available for Access or text files.
90