SQL Request Options

SQL Request Options

/commandTimeout=<seconds>

Use this option to change the command execution timeout.

/connectionTimeout=<seconds>

Use this option to change the server connection timeout.

/noTransaction

Use this option to disable the transaction mode.

You may turn off the transaction mode, for example, for deleting database objects using scripts.

Otherwise, the server rollbacks the transaction if any of the deleted objects does not exist.

/noWarnings

Use this option to suppress output of warning messages to the console.

/parse

Use this option to check how gsqlcmd parses SQL scripts into SQL commands in the exec mode.

For example:

gsqlcmd exec db script.sql /parse

/prepare

Use this option to get the final script that would be executed in the exec mode.

For example:

gsqlcmd exec db script.sql /prepare /set=param1=value1;param2=value2

You may execute the result code in the exec mode or using another tool.

/trace

Use this option to turn on tracing SQL commands sent to a server.

By default, gsqlcmd writes trace messages to the console.

You may define a log file in gsqlcmd.exe.config located in the gsqlcmd home directory.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.