-K is not supported in the CTP for SUSE Linux. You can, however, specify the ApplicationIntent=ReadOnly keyword in a DSN file passed to sqlcmd. For more information, see "DSN Support in sqlcmd and bcp" at the end of this topic.
Specify the number of seconds before a sqlcmd login to the ODBC driver times out when you try to connect to a server.
Control which error messages are sent to stdout.
Always specify -M when connecting to the availability group listener of a SQL Server 2012 availability group or a SQL Server 2012 Failover Cluster Instance. -M provides for faster detection of and connection to the (currently) active server. If –M is not specified, -M is off. For more information about AlwaysOn Availability Groups, see ODBC Driver on Linux Support for High Availability, Disaster Recovery.
-M is not supported in the CTP for SUSE Linux. You can, however, specify the MultiSubnetFailover=Yes keyword in a DSN file passed to sqlcmd. For more information, see "DSN Support in sqlcmd and bcp" at the end of this topic.
Identify the file that receives output from sqlcmd.
Print performance statistics for every result set.
Specify a user password.
Execute a query when sqlcmd starts, but does not exit sqlcmd when the query has finished running.
Execute a query when sqlcmd starts. sqlcmd will exit when the query finishes.
Redirects error messages to stderr.
Causes the driver to use client regional settings to convert currency and date and time data to character data. Currently only uses en_US (US English) formatting.
Specify the column-separator character.
-S [protocol:] server[,port]
Specify the instance of SQL Server to which to connect. Or, if -D is used, a DSN. The ODBC driver on Linux requires -S. For the ODBC driver on Linux, tcp is the only valid protocol.
Specify the number of seconds before a command (or SQL statement) times out.
Specify that output_file is stored in Unicode format, regardless of the format of input_file.
Specify a user login ID.
Control the severity level that is used to set the ERRORLEVEL variable.
Specify the screen width for output.
Remove trailing spaces from a column.
Disable variable substitution.
Disable commands, startup script, and environment variables.
Set the sqlcmd scripting variable SQLCMDMAXFIXEDTYPEWIDTH.
Set the sqlcmd scripting variable SQLCMDMAXVARTYPEWIDTH.
In the current release, the following sqlcmd commands are available:
In the current release, the following sqlcmd options are not available:
Log in to SQL Server with a Dedicated Administrator Connection (DAC). For information on how to make a dedicated administrator connection (DAC), see Programming Guidelines.
Specify the input and output code pages.
List the locally configured server computers, and the names of the server computers that are broadcasting on the network.
Create a sqlcmd scripting variable that can be used in a sqlcmd script.
You can use the following alternative method:
Put the parameters inside one file. Which you can then append to another file. This will help you use a parameter file to replace the values. Create a file called a.sql (the parameter file) with the following content:
You can specify a data source name (DSN) instead of a server name in the sqlcmd or bcp-S option (or sqlcmd :Connect command) if you specify -D. -D causes the -S option to retrieve the specified DSN. sqlcmd or bcp connect to the server specified in the DSN.
System DSNs are stored in the odbc.ini file in the ODBC SysConfigDir directory (/etc/odbc.ini on standard installations). User DSNs are stored in .odbc.ini in a user's home directory (~/.odbc.ini).
The following entries are supported in a DSN on Linux:
Driver=ODBC Driver 11 for SQL Server
In a DSN, only the DRIVER entry is required, but to connect to a server, sqlcmd or bcp need the value in the SERVER entry.
If the same option is specified in both the DSN and the sqlcmd or bcp command line, the sqlcmd or bcp option override the value used in the DSN. For example, if the DSN has a DATABASE entry and the sqlcmd command line includes -d, the value passed to -d is used. If Trusted_Connection=yes is specified in the DSN, Kerberos authentication is used, and user name (–U) and password (–P) , if provided, is ignored.
Existing scripts that invoke isql can be modified to use sqlcmd by defining the following alias: alias isql="sqlcmd –D".