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

Table Partition

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

 =>
 =>
 =>

 -------------------------------------------------------------------------------
 DATACOM/DB STRUCTURE MAINTENANCE                                      PARTITION
                                                                            TUCU
 ....................... TABLE PARTITION ATTRIBUTES ............................
 Name: ACCTS-PART-1                               Status/Version: T001
     DB Name: AC1                      SQL Name:
 Of TBL:  ACCTS                               CUST-ID-PARTITION
 .......................... PARTITION COLUMN VALUES ............................
        Column                              Type Length Sign Decimals
          Partition Column Value
          Len Sgn Value
 ====== ======================= T O P ==     =   =====   =      ==



        CUST-ID                              C   00005   N      00




 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'). 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 about 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)

Note: The line beginning "Of Table" is informational only and contains the name of the Partitioned Table and the Partitioning Key.

In each detail line (one per partitioning column):

Note: The first line of the detail repeating lines contains the name of the partitioning column and descriptive attributes. This data is informational only and is not modifiable.

Partition Column Value:

(Required) Enter the CA Datacom Datadictionary occurrence name of the Partition Column Value occurrence being defined.

Valid Entries:

1- to 32-character name

Default Value:

(No default)

Len:

(Optional) Enter the length of the data entered in the Value attribute if not consistent with the data type and length of the column. For example if the Type is "D" (packed decimal) with Length as "4" and you enter "12" in the Value, this field should contain "2".

Valid Entries:

0 to 60

Default Value:

(No default)

Sgn:

(Optional) If the Type is one of the accepted numeric types, enter the sign applied to the Value.

Valid Entries:

+, -, or N (no sign)

Default Value:

+

Value:

(Required) Enter the actual value used to determine the upper bound of the data contained in this partition. The value entered must be consistent in type and length with the attributes of the column. Values can also be entered in hex format. For example a value of "A123' in a character column can be entered as "X'C1F1F2F3'". The term "HIGH-VALUES" is reserved and must be used for all columns in the last partition (that is, the partition to contain the highest values of all the partitions of the parent.

Valid Entries:

Any valid string of characters based on the Type and Length.

Default Value:

(No default)