NAME

NAME is a special dimension that is used to organize the list of objects in a workspace. Its values are the names of the objects defined in the workspace.

Data type

TEXT

Syntax

NAME

Notes

LIMIT and STATUS with NAME

To see the names of all your workspace objects, use the LISTNAMES command. To see only some of the names, first limit the NAME dimension to the values in which you are interested, then use the STATUS command or the STATLIST function. See Example 18-12, "Listing Dimensions".

Changing the Values of NAME

You cannot change the values of the NAME dimension with the MAINTAIN command. You must use DEFINE, DELETE, MOVE, or RENAME to change its values. Also, you cannot define an object dimensioned by NAME.

Listing Objects in an Attached Workspace

When you are have more than one workspace attached, the values in the NAME dimension include only the objects in the current workspace, which is listed first on the workspace list. You cannot list the objects in another attached workspace unless you make it the current workspace by reattaching it with the FIRST keyword. See AW ATTACH for more information.

NAME Dimension and QONs

You cannot use a qualified object name to specify the NAME dimension of a workspace that is not the current workspace, for example when you are using the LIMIT command on the NAME dimension.

TEXT, Not NTEXT

All object names must have the TEXT data type, not the NTEXT data type. Therefore, object names cannot contain characters that do not exist in the database character set.

Examples

Example 18-12 Listing Dimensions

Suppose you want a list of all the dimensions in a workspace. First, use the LIMIT command and the OBJ function to limit the status of the NAME dimension. Then use the STATUS command to produce a list of dimensions. Since the values returned by OBJ(TYPE) are always in uppercase, you must use 'DIMENSION' (not 'dimension') in the LIMIT command to get a match. The statements

LIMIT NAME TO OBJ(TYPE) EQ 'DIMENSION'
STATUS NAME

produce the following output.

The current status of NAME is:
PRODUCT, DISTRICT, DIVISION, LINE, REGION, MARKETLEVEL, MARKET,
MONTH, YEAR, QUARTER

Example 18-13 Listing Relations

Suppose you want to see the definitions of all the relations in a workspace. Use the LIMIT command and the OBJ function to select these names. Then use DESCRIBE to produce a list of their definitions. The statements

LIMIT NAME TO OBJ(TYPE) EQ 'RELATION'
DESCRIBE

produce the following output.

DEFINE REGION.DISTRICT RELATION REGION <DISTRICT>
LD REGION for each DISTRICT
 
DEFINE DIVISION.PRODUCT RELATION DIVISION <PRODUCT>
LD DIVISION for each PRODUCT
 
DEFINE MLV.MARKET RELATION MARKETLEVEL <MARKET>
 
DEFINE MARKET.MARKET RELATION MARKET <MARKET>
LD Self-relation for the Market Dimension