To disconnect from the current session, the application issues the disconnect statement. To disconnect a session other than the current session, specify the numeric session identifier or connection name. The disconnect all statement disconnects all sessions started with the connect statement. It does not disconnect any Ingres-generated sessions, including the initial or default session. Ingres-generated sessions are disconnected when the application exits.

After an application disconnects from the current session in a multi-session application, the application must issue the set connection, set_sql(session), or connect statement to establish another current session before issuing any database statements. If no current session is in effect when an application issues a query, Ingres returns an error.