Allows modification of an existing driver, which was created previously with CREATE DRIVER.

Syntax

ALTER DRIVER name SET OPTIONS(key 'value' [,..n] );

Arguments

  • 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.

Additional Information

  • The ALTER DRIVER command cannot be used to modify the driver type. Drop and recreate if type needs to be changed.

Examples

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 '' );