ODBC_DISCONNECT Procedure
Disconnect from an ODBC.
 
Restriction
See Support for optional PV-WAVE modules 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 
See Also