From InterBase
Jump to: navigation, search

Go Up to Statement and Function Reference (Language Reference Guide)

Reconnects to the latest successfully connected database. RECONNECT is only available in isql and in SQL scripts that you run in isql.



RECONNECT [USER <username>] [PASSWORD <password>] [ROLE <rolename>] [CACHE <number>];
Argument Description

USER <username>

String or host-language variable that specifies a user name for the database. The server checks the user name against the security database. User names are case-insensitive.

PASSWORD <password>

String or host-language variable, that specifies a password for the database. The server checks the password against the security database. Passwords are case-sensitive.

ROLE <rolename>

String or host-language variable up to 67 characters in size, that specifies the role that the user adopts for this connection to the database. The user can adopt at most one role per connection, and cannot switch roles (except by reconnecting).

CACHE <number>

Sets the number of cache buffers for a database, which determines the number of database pages a program can use at the same time. Values for <number>:

  • Default: 256
  • Maximum value: system-dependent


The RECONNECT statement connects to the last successfully connected database. All parameters for the RECONNECT statement are optional. If you do not specify a parameter, RECONNECT uses the value that you pass via Command-line Options.


RECONNECT USER 'sysdba' PASSWORD 'masterkey';
RECONNECT USER 'sysdba' PASSWORD 'masterkey' ROLE 'DBA';

See Also

Personal tools
Previous Releases:
In other languages