ODBC_DISCONNECT Procedure
Disconnect from an ODBC.
Restriction: See "Supported Platforms Guide" on the PV-WAVE Documentation website to check if this function is available on your operating system.
Usage
ODBC_DISCONNECT, connect_handle
Input Parameters
connect_handle—The connection handle to be freed. The connection handle is the value returned by ODBC_CONNECT.
Discussion
Use this procedure to disconnect from the data source when:
You are finished importing data from a data source and want to end the session and free the DBMS license seat.
You want to access the same data source, but using a different login string and the driver doesn't support multiple connections to the same DSN.
Example
In this example, the ODBC_DISCONNECT procedure is used to disconnect from the ORACLE database.
env_handle=ODBC_INIT()
oracle_id = ODBC_CONNECT(env_handle, 'ORACLE','scott/tiger')
emp = ODBC_SQL(oracle_id, 'SELECT * from emp')
ODBC_DISCONNECT, oracle_id
INFO, /Structure, emp
