Altering nickname options

Nickname options are parameters that you specify on the nickname when you issue the CREATE NICKNAME and ALTER NICKNAME statements. You can add, set, or drop nickname options by using the ALTER NICKNAME statement.

Before you begin

The authorization ID issuing the statement must include at least one of the following privileges:
  • SYSADM or DBADM authority
  • ALTER privilege on the nickname specified in the statement
  • CONTROL privilege on the nickname specified in the statement
  • ALTERIN privilege on the schema, if the schema name of the nickname exists
  • Definer of the nickname as recorded in the DEFINER column of the catalog view for the nickname

About this task

Restrictions

See Restrictions on altering nicknames.

Procedure

To change a nickname option from the command line prompt, issue the ALTER NICKNAME statement. 
ALTER NICKNAME nickname 
    OPTIONS (SET option_name 'option_string_value')
Example: The nickname DRUGDATA1 is created for the table-structured file drugdata1.txt. The fully qualified path that was originally defined in the CREATE NICKNAME statement was /user/pat/drugdata1.txt. To change the FILE_PATH nickname option, issue the following statement:
ALTER NICKNAME DRUGDATA1 OPTIONS (SET FILE_PATH ’/usr/kelly/data/drugdata1.txt’)