Enables you to change
the server–based DSN. You can change the name and alter advanced
options. For information about which advanced options are supported
for each data source, see the Driver Reference chapter for your driver.
ALTER DSN dsn-namealter-dsn-options
ALTER DSN dsn-name RENAME TO new-dsn-name
ALTER DSN dsn-name ADD "(" dsn-name ["," ...] ")"ALTER DSN dsn-name DROP "(" dsn-name ["," ...] ")"
alter-dsn-options
Specifies the options
to alter.
alter-dsn-options
::= create-dsdsn-options
new-dsn-name
Specifies the new DSN
name.
ALTER DSN "DSN1" DESC 'altering DSN1 description' NOPROMPT
'DRIVER=BASE;CATALOG="catalog1_BASE";SCHEMA=(name="schema1_BASE")'
ALTER DSN "DSN5" RENAME to DSN7
ALTER DSN "DSN7" {OPTIONS set (FEDSQL
YES,SECURITY YES)}ALTER DSN "DSN7" {OPTIONS xset CREDENTIALS_SEARCH_ORDER(SHARED),
xset FEDSQL NO, xset SECURITY NO}ALTER DSN "DSN7" {OPTIONS DROP FEDSQL, DROP SECURITY}