Shell Programming and Scripting

 
$ isql --help

 
 
$ isql --help
usage: isql [option1] [option2] ... where [options] are ...
  -b                   Disables the display of the table headers output.
  -e                   Echoes input.
  -F                   Enables the FIPS flagger.
  -p                   Prints performance statistics.
  -n                   Removes numbering and prompt symbol when used with -e.
  -v                   Prints the version number and copyright message.
  -W                   Turn off extended password encryption on
                       connection retries.
  -X                   Initiates the login connection to the server with
                       client-side password encryption.
  -Y                   Tells the Adaptive Server to use chained transactions.
  -Q                   Enables the HAFAILOVER property.
  -a display_charset   Used in conjunction with -J to specify the character set
                       translation file (.xlt file) required for the conversion.
                       Use -a without -J only if the client character set is
                       the same as the default character set.
  -A packet_size       Specifies the network packet size to use for
                       this isql session.
  -c cmdend            Changes the command terminator.
  -D database          Selects the database in which the isql session begins.
  -E editor            Specifies an editor other than the default editor vi.
  -h header            Specifies the number of rows to print between
                       column headings.
  -H hostname          Sets the client host name.
  -i inputfile         Specifies the name of the operating system file
                       to use for input to isql.
  -I interfaces_file   Specifies the name and location of the interfaces file.
  -J client_charset    Specifies the character set to use on the client.
  -K keytab_file       Specifies the path to the keytab file used
                       for authentication in DCE.
  -l login_timeout     Specifies the number of seconds to wait for the server
                       to respond to a login attempt.
  -m errorlevel        Customizes the error message display.
  -M labelname labelvalue
                       Used for security labels. See CS_SEC_NEGOTIATE
                       for more details.
  -o outputfile        Specifies the name of an operating system file to 
                       store the output from isql.
  -P password          Specifies your Adaptive Server password.
  -R remote_server_principal
                       Specifies the principal name for the server as defined 
                       to the security mechanism.
  -s col_separator     Resets the column separator character, which is
                       blank by default.
  -S server_name       Specifies the name of the Adaptive Server to which.
                       to connect to.
  -t timeout           Specifies the number of seconds before a SQL command
                       times out.
  -U username          Specifies a login name. Login names are case sensitive.
  -V [security_options]
                       Specifies network-based user authentication.
                       Valid [security_options]:
                       c - Enable data confidentiality service.
                       i - Enable data integrity service.
                       m - Enable mutual authentication for connection
                           establishment.
                       o - Enable data origin stamping service.
                       q - Enable out-of-sequence detection.
                       r - Enable data replay detection.
                       d - Requests credential delegation and forwards
                           client credentials.
  -w column_width      Sets the screen width for output.
  -y sybase_directory  Sets an alternate location for the Sybase home directory.
  -z localename        Sets the official name of an alternate language to
                       display isql prompts and messages.
  -Z security_mechanism
                       Specifies the name of a security mechanism to use
                       on the connection.
  -x trusted.txt_file  Specifies an alternate trusted.txt file location.
  --retserverror       Forces isql to terminate and return a failure code when
                       it encounters a server error of severity greater than 10.
  --conceal [wildcard] Obfuscates input in an ISQL session. The optional
                       wildcard will be used as a prompt.
  --appname application_name
                       Replaces the default 'isql' application name in
                       the server with 'application_name'.
  --history [p]length [--history_file file_name]
                       Activates command history of <length> commands in isql.
                       With 'p' history will be saved at the end of the session.
                       --history_file file_name  Path to, and including name of
                                                 the command history file.