NAME
      reconnect - reestablish a database connection

SYNOPSIS
      reconnect [OPTION...]

DESCRIPTION
      Disconnect and reconnect to the database. You may provide new connection information to use on reconnect.

      If the connection is from a Query Analyzer window, this command will attach the current connection from the Query Analyzer window to the FluidShell session.

      If the ${DATABASE} shell variable is defined, it overwrites the previously used database name. If -d option is specified, it overwrites both ${DATABASE} shell 
      variable and previously used database name.

OPTIONS
      -ap
      Ask for the password.

      -au
      Ask for the user name.

      -auth {SQLSERVER | WINDOWS | SINGLESIGNON}
      SQL Server authentication.

      -ca {NORMAL | SYSOPER | SYSDBA | SYSASM}
      Connect to Oracle as.

      -ct {LOCAL | SERVER}
      Connect to Apache Derby.

      -d DATABASE
      Set the database name to switch into upon connect.

      -p PASSWORD
      Set the password.
 
      -s SCHEMA
      sets the schema to be used

      -sp SECURE_STORAGE_NAME
      Read the password from the secure storage.

      -su SECURE_STORAGE_NAME
      Read the user name from the secure storage.

      -u USER
      Set the user name.

      -v
      Verbosely report information about re-established connection.

EXAMPLES
      To reconnection to a SQL Server 2000 database with the SQL Server authentication in a Linux machine, use the below command. MS SQL SERVER 2000 is the server
      name found in the Servers Tree

reconnect 'Aqua Servers Tariq/SQL Server/MS SQL SERVER 2000' -d Northwind -u SA -p tariq -auth SQLSERVER

      To prompt for username and password before reconnecting use the -au and -ap options:

reconnect 'Aqua Servers Tariq/SQL Server/MS SQL SERVER 2000' -d Northwind -au -ap

 
      To read the username and password from secure storage under File > Options > Secure Storage, use the below command. Create the secure storage objects myuser and mypass, before executing this command

reconnect 'Aqua Servers Tariq/SQL Server/MS SQL SERVER 2000' -d Northwind -su myuser -sp mypass

NOTES
      USER option order of acceptance [-u, -au, -su], [-p, -ap, -sp]

      -auth: SQL Server Only

      -ca: Oracle Only

      -ct: Apache Derby Only

      -d: This option will be ignored if it is not supported by the connected server, e.g. SQLite.

      -s: This option will be ignored if it is not supported by the connected server, e.g. SQLite.

SEE ALSO
      connect
      disconnect 
      session