Script Commands

Script Commands provide ability to access some of the functionality which is available through different menus

cmd command_name [=] command_options

where:

cmd required and indicates the start of a command
command_name one of the supported commands
command_options - command options if any

Supported Script Commands:

cmd results = grid | text             -- Set results output destination
cmd results_only = Y | N              -- Include results only
cmd result_new = [name]               -- Add new result tab and make it current
cmd result_current = name             -- Set current result tab    
cmd result_name = name                -- Set result tab name
cmd export = excel                    -- Export to Excel
cmd export = file filename            -- Export to file
cmd message ['] message text [']      -- Add message to Messages tab

Remarks

Script command can be the first statement in SQL batch or the only statement in the batch.

cmd result_new = customers -- Add a tab with the name customers
select * from customer

cmd result_new = customers -- Add a tab with the name customers
go -- database specific batch separator
select * from customer

Export script command applies to the next SQL statement. For example to export result of the query to excel

cmd excel export
select * from customer