Chapter Contents

Previous

Next
GROUP=

GROUP=



Defines the groups within the record

Optional statement
Applies to: access descriptor


Syntax
Details
Arguments

Syntax

GROUP= group-name LEVEL=level-number <KEY=Y|N|U> <OCCURS=number-of-repeats> <SEARCH=search-name>;


Details

The GROUP= statement defines the groups within the record. This statement is optional.

See Handling GROUP Keys in Descriptor Files for information about how to reference GROUP keys in a view descriptor's WHERE statement.


Arguments

In the GROUP= statement, you must enter the group name and level number. The other arguments are used to further define the group and are not required. The following list explains each argument that can appear in a GROUP= statement:

GROUP=
GR=
is the name that you want to assign to the group item in an IMS-DL/I database. This name can be a maximum of 32 characters. If any special characters or blanks are included in the name, enclose the entire name in quotation marks. This is a required argument.

LEVEL=
LV=
is the two-character numeric level of the IMS-DL/I item. This level number is similar to the COBOL level number. Groups have levels greater than 01, and their level numbers are less than the level numbers of the items within the group. This is a required argument.

KEY=
K=
indicates with an Y, N, or a U whether this item is defined in the DBD as a sequence or key field and whether the key sequence field is unique. The default setting, N, indicates the field is not a key sequence field. You must assign one key sequence field per segment if you plan to use the view descriptors that are created from this access descriptor to update the IMS-DL/I database. Keys are recommended, but not required, for all segments except the lowest hierarchical level if the view descriptors will be used only for data retrieval. When KEY=U, retrieval calls to IMS will be reduced because the IMS engine will know that there is only one segment in the database for this key.

OCCURS=
O=
indicates the number of times a repeating group occurs. This is an optional argument.

SEARCH=
SE=
is the search field name defined for the group item in the DBMS DBD. If you want the IMS-DL/I engine to create SSAs directly from a WHERE statement or command, you must enter the search field names. Otherwise, the WHERE statement is passed to the SAS System and all of the segments in the database that are referenced in the view descriptor are read. SEARCH= is an optional argument, but it is recommended where applicable.

Note:   See Handling GROUP Keys in Descriptor Files for important information about searching at the GROUP level. Also see Performance and Efficient View Descriptors for more information about SSAs and WHERE statements. for important information about searching at the GROUP level.  [cautionend]


Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.