SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-5
ALTER DEFINE Command
ALTER DEFINE Command
Considerations for ALTER DEFINE
Examples of ALTER DEFINE
The ALTER DEFINE command changes a DEFINE in the current MXCI session.
(ALTER DEFINE is similar to the TACL command ALTER DEFINE.)
You can use ALTER DEFINE only within an MXCI session.
define
is the name of the existing DEFINE to change. DEFINEs can be inherited from the
TACL process or the OSS shell and modified within MXCI. DEFINEs can also be
created within MXCI and then modified within MXCI. See ADD DEFINE Command
on page 4-3.
A DEFINE name must not include a reserved word. Otherwise, you cannot select
data using the DEFINE name of the table, view, or partition. See Appendix B,
Reserved Words.
CLASS MAP
specifies that the DEFINE name define is associated with the name of a table,
view, or partition. Use the DEFINE name in SQL statements as the logical name of
an object, altering the DEFINE when you want to point to a different physical entity.
MAP is the default CLASS.
FILE [\node.][[$volume.]subvol.]filename
specifies the Guardian physical name of a table, view, or partition. \node is the
name of a node on a NonStop system, $volume is the name of a disk volume,
subvol is the name of a subvolume, and filename is the name of a Guardian
disk file. If the physical name is not fully qualified, it is expanded by using the
current default node, volume, and subvolume.
The Guardian physical name must not include a reserved word. Otherwise, you
cannot select data by using the DEFINE name of the table, view, or partition. See
Appendix B, Reserved Words.
Considerations for ALTER DEFINE
Scope of ALTER DEFINE
When you end an MXCI session, DEFINEs that you inherited from the TACL process
or the OSS shell and modified within MXCI revert to the values they had when you
started MXCI. You cannot alter an inherited DEFINE within MXCI.
ALTER DEFINE define
[,CLASS MAP], FILE [\node.][[$volume.]subvol.]filename