Progress
Language Reference
DISCONNECT Statement
Disconnects the specified database.
SYNTAX
logical-name
A logical database name. It can be an unquoted string or a quoted string. The logical-name is previously set, at startup or with a CONNECT statement, by using the Logical Database Name (-ld) parameter. If a logical name was not specified using the -ld parameter, then the physical database filename, without the .db suffix, is the default logical name.
VALUE (expression)
A character-string expression that evaluates to a logical database name.
NO-ERROR
Specifies that any errors that occur when you try to disconnect are suppressed. After the DISCONNECT statement completes, you can check the ERROR-STATUS system handle for information on errors that might occurred.
EXAMPLEThis procedure disconnects the database with logical name mydb.
NOTES
- By default, the Progress 4GL disconnects all databases at the end of a session. The DISCONNECT statement, which explicitly disconnects a database, does not execute until all active procedures that reference the database end or stop.
- If a transaction is active for logical-name, DISCONNECT is deferred until the transaction completes or is undone. If a CONNECT statement for the same logical-name database is executed before the same transaction completes or is undone, then the pending CONNECT and DISCONNECT cancel each other and the database remains connected.
- When the database referred to by logical-name is disconnected, existing aliases for logical-name remain in existence. Later, if you connect to a database with the same logical-name, the same alias is still available.
SEE ALSO
ALIAS Function, CONNECT Statement, CONNECTED Function, CREATE ALIAS Statement, CREATE DATABASE Statement, DATASERVERS Function, DBCODEPAGE Function, DBCOLLATION Function, DBRESTRICTIONS Function, DBTYPE Function, DBVERSION Function, DELETE ALIAS Statement, FRAME-DB Function, LDBNAME Function, NUM-DBS Function, PDBNAME Function, SDBNAME Function
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |