Like 0

go

NAME

go - execute database statements

SYNOPSIS

go [OPTION]

DESCRIPTION

Send the contents of the Work Buffer to the database. It then displays the results of the query and returns, causing the Work Buffer to be cleared and moved to the end of the History Buffer.

OPTIONS

-i VARIABLE_NAME=COLUMN_INDEX
Save the value of the cell at row 1 and column index COLUMN_INDEX into shell variable VARIABLE_NAME. COLUMN_INDEX is 1-based. This option can be repeated.

-k, --session-id SESSION_ID
Use the server connection associated with the session identified by SESSION_ID.

-n VARIABLE_NAME=COLUMN_NAME
Save the value of the cell at row 1 with name COLUMN_NAME into shell variable VARIABLE_NAME. This option can be repeated.

EXAMPLES

$ select top 25 * from orders
$ go

To redirect the output of the select statement to a file, use the command go together with >>. SQL statements and the symbols / @ or ; cannot be combined with redirection and pipelines.

$ select top 25 * from orders
$ GO >> rows.txt

Execute a query on the currently connected server and save the values of the first two columns of the first row to shell variables 'v_one' and 'v_two':

SELECT * FROM table
go -i v_one=1 -i v_two=2

Execute a query on the currently connected server and save the values of columns 'c2' and 'c3' of the first row to shell variables 'v_one' and 'v_two':

SELECT c1, c2, c3 FROM table
go -n v_one=c2 -n v_two=c3

NOTES

For -i and -n options, a new variable is created if the specified variable does not exist; if the query returns nothing, an empty string is saved to the specified variable. If the specif ied variables already exist but query execution failed, the contents of existing variables will n ot be cleared.

If two different columns are specified by -i and -n options but both of them point to the same variable, the value of the column specified by -n is used.

SEE ALSO

source

Comments (0) Attachments (0)

This list is empty.

Search Tips

Aqua Data Studio / nhilam

go

Search Tips

Aqua Data Studio / nhilam

Title

go