disconnect()

The sqlLib.disconnect() system function disconnects from the specified database or (if no database is specified) from the current database. If you do not specify another connection (either through sqlLib.connect() or sqlLib.setCurrentDatabase()) before making an SQL call, EGL attempts to make the call on the default database. For a Java™ run unit, the default database is specified in the vgj.jdbc.default.database runtime property; for more informatoin, refer to the EGL Generation Guide.

Before disconnecting, you can call sysLib.commit() or sysLib.rollback().

Syntax

  sqlLib.disconnect(
    [database STRING in] )
database
A database name (or alias) that was specified in sqlLib.connect(). Input can be any variable or expression that is assignment compatible with the STRING type (see "Assignment compatibility in EGL").

Feedback