ALTER DRIVER name SET OPTIONS(key 'value' [,..n] );
name - The name of an existing driver.
key ‘value’: One or more key-value pairs, from the following.
NAME: The driver name.
CLASSNAME: The driver’s classname. See CREATE DRIVER for a list of potential classnames.
INCLUDE_PARENT_CLASSPATH - Include Cirro classpath when loading JDBC driver. Only set true when using HIVE drivers after guidance from Cirro Support.
- The ALTER DRIVER command cannot be used to modify the driver type. Drop and recreate if type needs to be changed.
Change the driver name from SQLSRV_DVR to SQLSRV_DRIVER.
ALTER DRIVER SQLSRV_DVR SET OPTIONS( NAME 'SQLSRV_DRIVER' );
Change the driver name and classname.
ALTER DRIVER SQLSRV_DRIVER SET OPTIONS( NAME 'SQLSRV_DRIVER2', CLASSNAME 'com.microsoft.sqlserver.jdbc.SQLServerDriver' );
Change the value of include parent classpath.
ALTER DRIVER SQLSRV_DVR SET OPTIONS( INCLUDE_PARENT_CLASSPATH 'true' );
Reset/empty the value of include_parent_classpath.
ALTER DRIVER SQLSRV_DVR SET OPTIONS( INCLUDE_PARENT_CLASSPATH '' );