ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 299

SQL Statements A - D

ALTER DBEFILE

The ALTER DBEFILE statement changes the TYPE attribute of a DBEFile.

Scope

ISQL or Application Program

SQL Syntax

ALTER DBEFILE

DBEFileName

SET TYPE = {TABLE

INDEX

MIXED}

Parameters

DBEFileName

speciﬁes the DBEFile to be altered.

TYPE = speciﬁes the new setting of the DBEFile's TYPE attribute. The following

are valid settings:

TABLE Only data (table, LONG column, or HASH) pages can be

stored in the DBEFile.

INDEX Only index pages can be stored in the DBEFile.

MIXED A mixture of data and index pages can be stored in the

DBEFile.

Description

• The type of an empty DBEFile, that is, a DBEFile in which no table or index entries

exist, can be changed without restriction.

• The type of a nonempty DBEFile can be changed from TABLE or INDEX to MIXED; no

other changes are allowed.

• Once a DBEFile contains primary pages for a HASH table, no other nonhash table,

index, or LONG data can be placed in that DBEFile.

• Before you can alter the type of a DBEFile in the SYSTEM DBEFileSet, other users'

transactions must complete. Other users must wait until the transaction that is

altering the DBEFile has completed.

Authorization

You must have DBA authority to use this statement.