Micro Focus Enterprise Test Server 2.3 Update 1 > Data Access > Database Access > SQL Option for DB2 > Reference > SQL Reference > SQL Statements > ALTER LOCATION

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;