isql Options (version 6.5)

isql /b

The /b option specifies that isql exits and returns a DOS ERRORLEVEL value when an error occurs. The value returned to the DOS ERRORLEVEL variable is 1 when the SQL Server error message has a severity of 10 or greater, otherwise the value returned is 0. DOS batch files can test the value of DOS ERRORLEVEL and handle the error appropriately.

isql /O

The /O option specifies that the behavior of earlier versions of isql is required and disables the following:

• EOF batch processing
• Auto console width scaling
• Wide messages
• Default DOS ERRORLEVEL value is -1

isql /l timeout

The /l option specifies the number of seconds before an isql login times out. If no timeout is specified, a command runs indefinitely; the default timeout for login to isql is eight seconds.