Specifies the name of the segment. Segment-name must be a 1- through 8-character name that follows the conventions described in 7.3, "Naming Conventions".
Segment-name must be unique within the dictionary.
Important! If the segment is an SQL segment in an application dictionary, you must dissociate any tables, indexes, and referential constraints associated with the segment's areas before you attempt to delete the segment by issuing a DROP SEGMENT statement.
Indicates that the segment contains data defined by a non-SQL schema. FOR NONSQL is the default. Valid on CREATE operation only.
Indicates that the segment contains data defined by an SQL schema. Valid on CREATE operation only.
Specifies the page group of the segment's areas. Page-group-number is an integer in the range 0 through 32767. The default is 0.
On a CREATE statement, specifies the maximum number of record occurrences that can be stored on a single page of the segment's areas. Maximum-record-count is an integer in the range 3 through 2727. The default is 255.
Reserves areas associated with the segment for tables and indexes in the named SQL schema. Sql-schema-name must identify an SQL schema defined in the dictionary or a warning will be issued.
If the segment already contains tables and indexes from other SQL schemas, CA IDMS/DB does not prevent access to them, however, no new ones can be defined.
On an ALTER statement, removes any previous SQL schema restriction for the segment.
For SQL segments only, maintains synchronization stamps at the table level. BY TABLE is the default.
When maintaining stamps at the table level, CA IDMS/DB updates the stamp for an individual table when the definition of the table or any associated calc, index, or constraint is modified.
This clause is ignored for segments defined as non-SQL.
For SQL segments only, maintains a synchronization stamp at the area level in addition to the stamps maintained for individual tables. When maintaining stamps at the area level, CA IDMS/DB updates the stamps for both the individual table and its area when the definition of any table in the area (or any associated calc, index, or constraint) is modified.
Maintaining stamps at the area level allows validation of access modules by area rather than by individual table.
This clause is ignored for segments defined as non-SQL.
Displays or punches information about all areas contained in the segment.
Displays or punches information about all DMCLS in which the segment is included.
Displays or punches information about all files contained in the segment.
Displays or punches information about all symbols defined to areas contained in the segment.
Displays or punches details about the segment.
Displays or punches:
Displays or punches all information about the segment. ALL is the default action for a DISPLAY or PUNCH verb.
Displays or punches the name of the segment.
|
Copyright © 2014 CA.
All rights reserved.
|
|