DB_DISCONNECT Procedure

Disconnects PV‑WAVE from an external database.

Usage

DB_DISCONNECT, dbms_id

Input Parameters

dbms_id—The DBMS ID (handle) that was returned by the DB_CONNECT function.

Keywords

None.

Discussion

Use this function when you:

are finished importing data from a database and want to end the session and free the DBMS license seat.

have accessed data from one database (e.g., mydb) and want to access data from a different database (e.g., yourdb).

want to access the same database (e.g., mydb), but using a different login string.

Example

In this example, the DB_DISCONNECT procedure is used to disconnect from the ORACLE database.

oracle_id = DB_CONNECT('ORACLE','scott/tiger')

emp = DB_SQL(oracle_id, 'SELECT * from emp')

DB_DISCONNECT, oracle_id

INFO, /Structure, emp

See Also

DB_SQL,  DB_CONNECT

See the following related functions in the PV-WAVE Reference:

BUILD_TABLE FunctionGROUP_BY Function,  ORDER_BY Function,  QUERY_TABLE Function, UNIQUE Function