Previous Topic Next topic Print topic


ALTER LOCATION

The ALTER LOCATION statement converts (upgrades) a location to DB2 Version 6, 7 or 8 compatibility.

Note:

By default, XDB Server creates locations that are compatible with DB2 Version 6, 7 or 8.

Invocation

ALTER LOCATION is an executable command that can be issued interactively, embedded in a host language or dynamically prepared.

Authorization

To execute the ALTER LOCATION command, users must have INSTALL or SYSADM privileges.

Syntax

ALTER LOCATION location-name TO {VERSION {V41 | V51 | V60 | V71 | V80} | SORT SEQUENCE language-name EBCDIC} 

Parameters:

location-name

Identifies the location to be converted.

  • swedish
  • classic
  • dutch
  • french
  • spanish
  • italian
  • uk
  • danish
  • norwegian
  • finnish
  • german
  • austrian
  • portuguese
  • us
  • international
  • turkish

Description

You can use most DB2 Version 7.0 and Version 8.0 features without converting your existing XDB Server locations. However, you cannot use new DDL-related features without upgrading. Once you convert a location to DB2 Version 7.0 and Version 8.0 compatibility, you cannot use it with an earlier version of the XDB Server.

Example:

alter location jbl to sort sequence german ebcdic;
Previous Topic Next topic Print topic