Description

This Article will guide you to Execute the Query from Command Line in Studio 11

Applies To

Studio 11x

Solution

Step 1: Make a note on which location the Script and the Data File is stored.
The below Command line has used four Commands

• -run: To run the Query Script specified in the path following the 'run' command

• -alf: To apply the Auto Logon File with the same order following the 'alf' command

• -rfn: To Write is the desired Data file in the path following the 'rfn' command.

Step 2: Execute the Query with the below Command Line
"C:\Program Files\Winshuttle\Studio\Winshuttle.Studio.Console.exe" -SapQuery -run"C:\Users\**yourusername**\Documents\Winshuttle\Studio\Script\Table_demo.Qsq" -alf"WE6-**yourusername**-800" -rfn"C:\Users\**yourusername**\Documents\Winshuttle\Studio\Data\Table_demo.xlsx"

Additional Information

Follow the below link for further commands that can be used to execute the Query in Command Line.

Using SyncCall property to True in order to pause the Macro until Query is finished is supported from version 12.1.1