DBMAINT Mode - DATACOM/DB Structure Maintenance › Partitioning a Table › Partitioned Table

Partitioned Table

If the PARTITION attribute-value for the table is Y, that is, it is a partitioned table, the following panel is displayed.

 =>
 =>
 =>
 1-DDOL000407I - UPIP - TABLE HAS NO RELATED PARTITION
 -------------------------------------------------------------------------------
 DATACOM/DB STRUCTURE MAINTENANCE                                      PARTITION
                                                                            TUPU
 ....................... PARTITIONED TABLE ATTRIBUTES ..........................
 Name: ACCTS                                      Status/Version: T001
     DB Name: ACT                    SQL Name: ACCTS
 Any DB Name:                    Any SQL Name:
 Move Row: _
 ............................. TABLE PARTITIONS ................................
        Table Partion                     Area
          DB-Nm  DB-ID  SQL Name
 ====== ======================= T O P ==  ================================
 000001 ________________________________  ________________________________
          ___    ___   _________________________________
 ====== ====================== B O T T O M  ==============================




 PF1=HELP  PF2=END  PF3=CLARIFY  PF4=PROCESS  PF5=MENU   PF6=STATUS
 PF7=SCB   PF8=SCF  PF9=APPLY    PF10=PATH    PF11=NEXT  PF12=INPUT

The following list describes the valid entries, and the default (if one exists) for each attribute that is modifiable. Attributes that require an entry are highlighted on your terminal. Attributes which are not highlighted indicate that an entry is optional. If you do not assign a value to these attributes, they default to the value assigned in CA Datacom Datadictionary.

In the header data:

DB Name:

(Required) Specify a name that is unique among the tables defined to the DATABASE structure. It cannot contain leading, embedded, or trailing blanks (X'40'). CA Datacom/DB uses this name to identify the table made up of all of the partitions. If any partition is not available, then this table cannot be opened. For more information, see the DATACOM-NAME attribute-type for TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:

A unique set of three characters where the first character is alphabetic

Default Value:

(No default)

SQL Name:

(Optional) Enter the SQL name of the table. For more information, see the section on naming standards in the CA Datacom Datadictionary User Guide.

Valid Entries:

1 to 18 characters if the SQL Precompiler option SQLMODE is set to ANSI or FIPS

1 to 32 characters if the SQL Precompiler option SQLMODE is set to DATACOM

Default Value:

(No default)

Any DB Name:

(Optional) Specify a name that is unique among the tables defined to the DATABASE structure. It cannot contain leading, embedded, or trailing blanks (X'40'). CA Datacom/DB uses this name to identify the table made up of any partitions which are available at the time the table is being accessed. For more information, see the ANY-DATACOM-NAME attribute-type for TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide. Also see the information about generic access to partitions in the CA Datacom/DB Database and System Administration Guide.

Note: The partitions that can be accessed using the ANY names can change while the task is running, after the table is opened.

Valid Entries:

A unique set of three characters where the first character is alphabetic

Default Value:

(No default)

Any SQL Name:

(Optional) Enter the SQL name of the table as defined under Any DB Name. See the section on naming standards in the CA Datacom Datadictionary User Guide for information.

Note: The Any Parent table has the same AUTHID as the Full Parent table.

Valid Entries:

1 to 18 characters if the SQL Precompiler option SQLMODE is set to ANSI or FIPS

1 to 32 characters if the SQL Precompiler option SQLMODE is set to DATACOM

Default Value:

(No default)

Move Row:

(Required) Defines whether an update of the value of a column used in a partition key is allowed (Y) if the change causes the row to be move to a different partition. Updates are allowed to these values regardless of this attribute-value as long as the update does not cause the row to be moved to a different partition.

Valid Entries:

N or Y

Default Value:

N

In each detail line (one per partition):

Table Partition:

(Required) Enter the CA Datacom Datadictionary occurrence name of the table partition (child).

Valid Entries:

1- to 32-character name

Default Value:

(No default)

Area

(Required) Enter the CA Datacom Datadictionary occurrence name of the AREA occurrence that contains the table partition (child) data. The AREA occurrence must have been previously defined in the DATABASE Structure.

Valid Entries:

1- to 32-character name

Default Value:

(No default)

DB-Nm:

(Required) Specify a name that is unique among the tables defined to the DATABASE structure. It cannot contain leading, embedded, or trailing blanks (X'40'). CA Datacom/DB uses this name to identify the table partition. For more information, see the DATACOM-NAME attribute-type for TABLE occurrences in the CA Datacom Datadictionary Attribute Reference Guide.

Valid Entries:

A unique set of three characters where the first character is alphabetic

Default Value:

(No default)

DB-ID:

(Optional) Enter the 1- to 3-digit CA Datacom/DB table identification number. If no attribute-value is entered, CA Datacom Datadictionary automatically assigns an available table ID when the database is copied to PROD status, or when the database is processed during a SET or CATALOG function.

Valid Entries:

1 to 240

Default Value:

An available table ID

SQL Name:

(Optional) Enter the SQL name of the table. For more information, see the section about naming standards in the CA Datacom Datadictionary User Guide.

Note: All partitions have the same AUTHID as the Parent table.

Valid Entries:

1 to 18 characters if the SQL Precompiler option SQLMODE is set to ANSI or FIPS

1 to 32 characters if the SQL Precompiler option SQLMODE is set to DATACOM

Default Value:

(No default)