ALTER DRIVER driverName SET OPTIONS( key 'value' [,..n] );
driverName: 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: A true/false value in single quotes, such as ‘false’. This value can be left empty to clear the value.
The ALTER DRIVER command cannot be used to modify the driver type.
If the type (which was set with the CREATE DRIVER command) must be changed, drop and recreate the driver.
--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 '' );