If Additional attributes is set to Y, a window is displayed containing additional attributes for selection.
Only those types of additional attributes appear in the window that apply to the type of field. For example: the option Adabas security & Edit mask is not contained in the list when a DB2 index field is processed.
More than one choice can be made at a time. The respective input maps are then displayed one after the other.
The additional attributes are described in the following sections:
13:06:25 ***** P R E D I C T ***** 2007-05-31
- Modify Field -
Field ID ........ HNO-EL1 Added 2007-05-31 at 12:55
File ID ......... HNO-FI1 by HNO
Ty L Field ID F Cs Length Occ D U DB N NAT-l
*- - -------------------------------- *- - -------- ----- * * -- * -----
1 HNO-EL1 A 2.0 AA N
Specifications for 3GL
Gr.structur ........ (n)
Justify ............ (R)
Synchronized ....... (S)
Initialize with ...*
Init value .......
Indexed by .........
Depending on .......
|
| Attributes | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Gr.structure |
The field attribute Gr.structure is used to change the record layout generated from a PE/PC field. If Gr.structure is set to N, all fields within a PE group are treated as multiple value fields. Setting Gr.structure to N prevents the format buffer for Adabas from becoming very large. Gr.structure = N can only be specified for real fields in the deepest PE group (highest level number). For example: if there are 3 PE groups in the file on level 1, 4 and 6, only the PE groups on level 6 can be marked with Gr.structure = N. If Gr.structure is set to blank, PE/PC groups are to be generated as groups which occur n times as a whole. |
||||||||||||||||
| Justify |
|
||||||||||||||||
| Synchronized |
|
||||||||||||||||
| Initialize with |
|
||||||||||||||||
| Init. value |
If Initialize with is either F or blank a value used for initialization of a field must/can be specified. Length and format of the Init value must be valid for the field. For binary fields hexadecimal constants such as FB0A are valid. Hexadecimal values can be specified in two ways:
See also Condition Name and Value. |
||||||||||||||||
| Indexed by | String that is used when generating the COBOL INDEXED BY clause (only valid for fields of type MU/MC or PE/PC). | ||||||||||||||||
| Depending on | String used when generating the COBOL DEPENDING ON clause (only valid for fields of type MU/MC or PE/PC). | ||||||||||||||||
13:04:26 ***** P R E D I C T ***** 2007-05-31
- Modify Field -
Field ID ........ VE-FIELD Modified 2007-05-31 at 12:21
File ID ......... HEB-A by HEB
Ty L Field ID F Cs Length Occ D U DB N NAT-l
*- - -------------------------------- *- - -------- ----- * * -- * -----
1 VE-FIELD A 3.0 AA N
Condition name FC * Condition value
Additional attributes ..* S Associations ..* N Scroll to .. 1
|
| Attributes | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Condition name |
A value to be used when generating either equate data in Assembler copy code or a level 88 entry in COBOL copy code. Up to 29,970 condition names can be entered. Each name needs at least one corresponding condition value. Using condition names can make logical conditions and assignments easier to handle. |
||||||||||||||||
| FC |
|
||||||||||||||||
| Condition value |
The length and format of this value must be valid for this field. This value must have a corresponding condition name. Up to 29,970 condition values can be entered. If several values correspond to the same name, put the name before the first value and leave the name field blank before later values. THRU in the name field indicates a range of values ending with the value on that line and beginning with the value on the previous line. |
||||||||||||||||
13:48:12 ***** P R E D I C T ***** 2007-05-31
- Modify Field -
Field ID ........ PD-A2 Added 2007-05-31 at 12:10
File ID ......... PD-A-TEST3 Modified 2007-05-31 at 13:08
Ty L Field name F Cs Length Occ D U DB N NAT-l
*- - -------------------------------- *- - -------- ----- * * -- * -----
2 PD-A2 A 2.0 AF
Field name synonyms
Natural .............
COBOL ...............
PL/I ................
BAL/Assembler .......
FORTRAN .............
Pascal ..............
Language ADA ........
Language C ..........
User defined ........
Additional attributes ..* S Associations ..* N
|
| Attributes | |
|---|---|
| Field name synonyms | Synonyms to be assigned to the field when definitions in the following programing languages are generated: Natural, COBOL, PL/I, BAL (Assembler), FORTRAN, PASCAL, ADA or C. |
This option is only provided for compatibility with old versions of Predict.
Whether this option is displayed depends on the parameter Old mode synonyms of the screen Defaults ->General defaults -> Synonyms:
| N | Default setting. Compatibility with old versions is not required. |
| Y | Up to 90 synonyms can be defined as Natural synonyms. These create additional entries in the DDM which have the same attributes as the original object but different names. |
13:10:46 ***** P R E D I C T ***** 2007-05-31
- Modify Field -
Field ID ........ PDS Modified 2007-05-31 at 13:01
File ID ......... PD-D1 by PD
Field synonym Field synonym
1 2
3 4
5 6
7 8
9 10
11 12
13 14
15 16
17 18
19 20
21 22
23 24
25 26
27 28
29 30
Additional attributes ..* S Associations ..* N Scroll to:
|
17:22:19 ***** P R E D I C T ***** 2011-09-05
- Modify Field -
Field ID ........ HNO-EL-A Added 2011-09-05 at 17:16
File ID ......... SMR-AV82 by HNO
Ty L Field ID F Cs Length Occ D U DB S NAT-l
*- - -------------------------------- *- * -------- ----- * * -- * -----
1 HNO-EL-A T AJ N
Adabas attributes
Edit mask .............*
Time zone .............. (Y/N)
Daylight saving ........ (Y/N)
Security access level .. (0-15)
Security update level .. (0-15)
Additional attributes ..* N Associations ..* N |
| Attributes | |||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Edit mask |
|
||||||||||||||||||||||||||||
| Time zone | The time zone in which a timestamp is applied. Only available for fields using one of the following Adabas edit masks described above: DT, NT, TS, UT or XTS. | ||||||||||||||||||||||||||||
| Daylight saving | The daylight savings indicator can only be specified for date-time fields defined with the TZ option. Indicates whether daylight saving applies (Y) or not (N). | ||||||||||||||||||||||||||||
| Security access level | The Adabas access security level of the field. | ||||||||||||||||||||||||||||
| Security update level | The Adabas update security level of the field. | ||||||||||||||||||||||||||||
Applicable only to DB2 fields of type D or MT, Oracle fields of type OT and to Adabas fields of type A.
The following screen shows the options for DB2 fields of type D and MT.
16:16:33 ***** P R E D I C T ***** 2011-11-17
- Modify Field -
Field ID ........ SUPER_HASH Added 2011-10-17 at 15:29
File ID ......... XYZ-D_HASH_PART by XYZ
Ty L Field ID F Cs Length Occ D U DB N Df NAT-l
*- - -------------------------------- *- * -------- ----- * * -- * *- -----
SP 1 SUPER_HASH D U AC
DBMS extensions in <Default Server>
Use as security label .. (Y,N)
Partitioning ..........* Q DPSI and table partitioning key
Use as hash key ........ Y (Y,N)
Cluster index .......... N (Y,N)
Exclude NULL keys ...... Y (Y,N)
* Additional attributes ..* S Associations ..* N |
Additional attributes are available for files of type D and MT that are used as accelerator tables.
18:17:10 ***** P R E D I C T ***** 2020-07-02
- Modify file -
File ID ......... XYZ-DB_V12 Modified 2020-04-06 at 13:35
by XYZ
DBMS extensions in <Default Server>
Keylabel name .... on default Zoom: N
Accelerator name . ACC IN D
* Additional attributes ..* S * Associations ..* S |
The following screen shows the options for Adabas fields of type A.
15:03:54 ***** P R E D I C T ***** 2011-11-10
- Modify Field -
Field ID ........ AA-FIELD Modified 2011-08-05 at 09:28
File ID ......... SMR-AV82 by XYZ
Ty L Field ID F Cs Length Occ D U DB N Df NAT-l
*- - -------------------------------- *- * -------- ----- * * -- * *- -----
MU 1 AA-FIELD A 8.0 300 AA
DBMS extensions
System field .........* JN Jobname
* Additional attributes ..* S Associations ..* N |
The following screen shows the options for Oracle fields of type OT.
17:55:26 ***** P R E D I C T ***** 2017-07-31
- Modify Field -
Field ID ........ XYZ_OT_INDEX Modified 2017-07-31 at 17:50
File ID ......... XYZ-OTI by XYZ
Ty L Field ID F Cs Length Occ D U DB N Df NAT-l
*- - -------------------------------- *- * -------- ----- * * -- * *- -----
1 XYZ_OT_INDEX A 15.0 AL U
DBMS extensions in XYZ-ORA1
Partitioning key ....*
Partitioned index ...*
Sort ................. (Y/N)
Cluster column ....... (Y/N)
Encryption ..........*
Integrity algorithm .*
Salt ................. (Y/N)
Include column ....... (Y/N)
* Additional attributes ..* S Associations ..* N |
| Attributes | ||
|---|---|---|
| Use as security label |
Specifies that the table column will contain security label values. A table can have only one security label column. To define a table with a security label column, the primary authorization ID of the statement must have a valid security label, and the RACF SECLABEL class must be active. In addition, the following conditions are also required:
Refer to your DB2 documentation for further details. |
|
| Partitioning | Indicates for each implementation of a table in an SQL server, which field controls the partitioning. Valid values: | |
| blank |
Non-partitioning. The current field is not a partitioning key and has no index. |
|
| T |
Table partitioning key. The table is data partitioned and the current field is the partitioning key. Additionally, it may have a non-partitioned index. |
|
| I |
Index controlled key. The table partitioning is controlled by a partitioning index. The current field must have an index defined; this is indicated by descriptor type D (index), P (primary key) or F (foreign index). |
|
| N |
Non-partitioned secondary index. The field has a non-partitioned index, but it is not the partitioning key. |
|
| P |
Data partitioned secondary index (DPSI). The field has a partitioned index, but it is not the partitioning key. Within the file a different field must be defined as partitioning key. |
|
| Q |
Table partitioning key and DPSI. The table is data partitioned and the current field is the partitioning key. In addition, a partitioned index is defined for the field. |
|
| Cluster index | Only available for descriptor type D (index), P (primary key) or F (foreign index). | |
| Y | The records (rows) in the DB2 table are stored in the sequence of this index. Valid for max. one index per table. A table contained in a partitioned tablespace must have one index marked as a clustered index, if the partitioning option Index controlled key is to be used. | |
| Use as hash key |
Only available for DB2 fields of type D. Indicates whether the current field is used as hash key. Must be unique. |
|
| Y | Yes. Must be set if the table is hash organized. | |
| N | No. | |
| Exclude NULL keys |
Only available for DB2 fields of type D and MT. Indicates whether NULL keys are excluded. |
|
| blank | Not specified. | |
| Y | Yes. | |
| N | No. | |
| System field |
Only available for Adabas fields of type A. Type of the system-generated field in Adabas. Valid values: |
|
| JN | Job name. For alphanumeric fields only. Length must be 8 or greater. | |
| OU | Open command user. For alphanumeric fields only. Length must be 8 or greater. | |
| SC | Security user. For alphanumeric fields only. Length must be 8 or greater. | |
| SI | Session ID. For alphanumeric fields only. Length must be 28 or greater. | |
| SU | Session user. For alphanumeric fields only. Length must be 8 or greater. | |
| T | Time. For numeric fields only. | |
| Index partitioning as default |
Note: Defines the preset values for the Partitioning and Cluster index attributes (see above in this table) when a new field is created using the Add a Field function. Valid values: |
|
| Y | If a new field is created using the Add a Field function and no cluster field exists on the file, the preset value for Partitioning is I (Index controlled key) and the preset value for Cluster index is Y. | |
| N | This is the default. The preset value for Partitioning is N (Non-partitioned secondary index) and the preset value for Cluster index is N. | |
| Keylabel name | This option can only be set for DB2 fields in files of type D and MT. Used for encryption. | |
| Accelerator name | This option can only be set for DB2 fields in files of type D and MT that are used as accelerator tables. For a definition of accelerator tables, refer to the IBM DB2 documentation. | |
| Partitioning key |
Only available for Oracle fields of type OT. Indicates how the partitioning key is organized: |
|
| R | Range partitioned. | |
| H | Hash partitioned. | |
| blank | None. | |
| Partitioned index |
Only available for Oracle fields of type OT. Indicates how the partitioned index is organized: |
|
| A | Global range. | |
| B | Global hash. | |
| C | Local range. | |
| D | Local hash. | |
| blank | None. | |
| Sort |
Only available for Oracle fields of type OT. Specifies whether the rows of the cluster on this column are sorted after applying the hash function |
|
| Cluster column |
Only available for Oracle fields of type OT. Specifies whether or not this field (or combination of fields in case of an SP field) is used as cluster column |
|
| Encryption |
Only available for Oracle fields of type OT. Specifies the encryption method to be used: |
|
| 1 | AES256 | |
| 2 | AES192 | |
| 3 | AES128 | |
| 4 | 3DES168 | |
| blank | None. | |
| Integrity algorithm |
Only available for Oracle fields of type OT. Specifies the integrity algorithm to be used: |
|
| S | SHA1 | |
| N | NOMAC | |
| blank | None. | |
| Salt |
Only available for Oracle fields of type OT. Specify SALT to instruct the database to append a random string to the clear text of the column before encrypting it. |
|
| Include column |
Only available for Oracle fields of type OT. If this column is part of the primary key, this column determines where to divide an index-organized table row into index and overflow portions. |
|
16:41:49 ***** P R E D I C T ***** 2007-05-31
- Add a Field -
Field ID ........ HNO_TEST Added 2007-05-31 at 16:41
File ID ......... HNO-DB2 by HNO
Ty L Field ID F Cs Length Occ D U DB N NAT-l
*- - -------------------------------- *- * -------- ----- * * -- * -----
1 HNO_TEST AL 100.0 AF U
Physical attributes in <Default Server> (new)
+-------------------------------------------------+
! Procedure name ....... !
! Procedure parameter !
! !
! !
! !
! !
! !
! / !
+-------------------------------------------------+
Additional attributes ..* S Associations ..* N |
| Attributes | |
|---|---|
| Procedure name | Name of a field procedure (DB2 parameter FIELDPROC). See the Natural for DB2 documentation for more details. |
| Procedure parameter | Parameters passed to the field procedure. See the Natural for DB2 documentation for more details. |
> > + EL: A5 L: 1 S: 1
All ....+....1... Expression for derived field..+....5....+....6....+....7..
*
* Field expression of a derived field
*
USER-TABLE1-SALARY * 12 /* SALARY FOR 12 MONTHS
+ CORRELATOR2-BONUS
|
Applicable only to fields of type DV in files of the following types:
| B | Adabas SQL views |
| E | DB2 views |
| IV | Intermediate view |
| JV | Ingres view |
| OV | Oracle view |
| X | General SQL |
| XV | Informix view |
| YV | Sybase view |
The expression used to derive the field is to be edited using one of the following depending on the your settings in the Profile > Handling screen:
the Natural-based Subquery Editor, or
the Software AG Editor
The editor can also be called with
function Edit Field expression (Code Y) in the Field Maintenance Menu, or
command EDIT ELEMENT EXPRESSION
file-id
field-id
See the section Editors in Predict in the Predict Reference documentation for more information.
The subquery of the file that contains the current field can specify a correlation name for any file whose fields it uses. The name of each field referenced in the expression must be qualified (preceded) by the correlation name of the file from which the field is taken, if a correlation namehas been specified for that file, or the ID of the file from which the field is taken, if no correlation name has been specified for it. The expression can include both comment lines (with /*, * or ** in the first two columns) and line comments (preceded by /*).
Example: A field which contains the annual salary:
* * Field expression of a derived field * USER-TABLE1-SALARY * 12 /* SALARY FOR 12 MONTHS + CORRELATOR2-BONUS
Index fields (descriptor type D, F or P) in a file of type D (DB2 table), are defined in the screens below.
0:55:34 ***** P R E D I C T ***** 2020-07-02
- Modify Field -
Field ID ........ EL_IDX Added 2020-01-28 at 09:26
File ID ......... XYZ-DB_V12 by XYZ
Index default definition in <Default Server>
Index name ......... XYZ-EL_IDX Number of partitions: 88
Cluster index ...... N (Y,N) Piece size ...* 0
Close option ....... Y (Y,N) Reverse scans . (Y,N)
Bufferpool ........* Padded ........ (Y,N)
Copy ............... N (Y,N) Compression ... (Y,N)
UQ where not null .* determined by gener. DSSIZE (G) ....
Default values of using- and free-block
VSAM catalog name ..
Storagespace ......*
Primary alloc ......
Secondary alloc.....
Erase opt .......... (Y,N)
Free pages .........
Percentage free ....
GBPCACHE ..........* Default
* Additional attributes ..* S Associations ..* N |
| Attributes | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Index default definition | |||||||||
| Index name | The name of the DB2 index. See Key or Index Fields in SQL Files - Superfields. A read-only field. | ||||||||
| Cluster index |
|
||||||||
| Bufferpool | The buffer pool associated with the index. | ||||||||
| Close option |
|
||||||||
| Copy |
|
||||||||
| Piece size |
The maximum piece size for a non-partitioned index. Valid values: 0, 256, 512, 1024, 2048, 4096, 8192, 16384, 32768, 65536, 131072, 262144, 524288, 1048576, 2097152, 4194304. |
||||||||
| Reverse scans |
|
||||||||
| Padded |
|
||||||||
| UQ where not null |
|
||||||||
| Compression |
|
||||||||
| DSSIZE | Specifies the maximum size (in Gbyte) for each partition of a partitioned index. | ||||||||
| Default Values of Using- and Free-Block | |||||||||
| VSAM catalog name | Name of the VSAM catalog for the index. The parameter VSAM catalog name must be specified if data sets are already defined for the index. | ||||||||
| Storagespace | Storagespace where DB2 defines the data sets for the index (optional). If no storagespace is specified, DB2 uses the default storagespace. | ||||||||
| Primary alloc | Minimum primary space allocation (in Kbyte) for DB2-defined index data sets. A value specified in this field is stored only if the attribute storage group has been specified. | ||||||||
| Secondary alloc | Minimum secondary space allocation (in Kbyte) for DB2-defined index data sets. A value specified in this field is stored only if the attribute storage group has been specified. | ||||||||
| Erase opt |
|
||||||||
| Free pages | A number from 0 to 255 which indicates that one page
is to be left free each time this number of pages is used when the load
operation creates index entries or when the index is reorganized. Zero indicates that no pages are to be left free. |
||||||||
| Percentage free | A number from 0 to 99: the percentage of each page to be left as free space when index entries are created by a load operation or when the index is reorganized. | ||||||||
| GBPCACHE |
|
||||||||
For a partitioned index (a cluster index for a table in a partitioned table space), the following screen is displayed for every two partitions. Each partition can then be defined in accordance with the Default values of using- and free-block (see description above).
21:13:44 ***** P R E D I C T ***** 2020-07-02
- Modify Field -
Field ID ........ EL_IDX Modified 2020-07-02 at 21:12
File ID ......... XYZ-DB_V12 by XYZ
SQL Server ...... <Default Server>
---------------------------- Partition definition -----------------------------
Partition 1
Value ..... Zoom: N
VSAM catalog name ..... DSSIZE (G) .......
Storagespace .........*
Primary allocation .... GBPCACHE ........*
Secondary allocation .. Free pages .......
Erase option .......... (Y/N) Percentage free ..
Hash size (KB)....
Partition 2
Value ..... Zoom: N
VSAM catalog name ..... DSSIZE (G) .......
Storagespace .........*
Primary allocation .... GBPCACHE ........*
Secondary allocation .. Free pages .......
Erase option .......... (Y/N) Percentage free ..
Hash size (KB) ...
* Additional attributes ..* N Associations ..* N * Scroll to .. 1 |
Note:
The data displayed in this screen depend on the values selected
in the Partitioning field of the DBMS extensions screen.
| Attributes | |
|---|---|
| Value |
The highest value of the index key in this partition. At least one constant must be used and as many constants as there are columns in the key can be specified. The concatenation of all the constants is the highest value of the key in this partition of the index. Note: |
| DSSIZE | The value of DSSIZE given in the PARTITION clause for that partition. |
All other attributes are described above.
Index fields (descriptor type D, F or P) in a file of type OT (Oracle table), are defined in the screens below.
14:30:37 ***** P R E D I C T ***** 2017-08-11
- Modify Field -
Field ID ........ IDENTITY Added 2017-08-11 at 14:30
File ID ......... XYZ-OTI by XYZ
Index attributes in XYZ-ORA1
REVERSE ............. (Y,N)
VISIBLE ............. Y (Y,N)
PARTIAL ............. Y (Y,N)
SORT ................ Y (Y,N)
COMPRESSION ........* Y Yes
Compression length .. 23
* Additional attributes ..* S Associations ..* N |
| Parameters | ||
|---|---|---|
| Field ID |
ID of the Predict object documenting the Oracle table field. |
|
| File ID |
ID of the Predict object documenting the Oracle table. See Naming Conventions for Oracle objects. |
|
| Index attributes | ||
| REVERSE | Specifies whether the index is a reverse key index. | |
| Y | Yes. | |
| N | No. | |
| VISIBLE | Specifies whether the index is visible. | |
| Y | Yes. | |
| N | No. | |
| PARTIAL | Specifies whether the index is a partial index in a partitioned table. | |
| Y | Yes. | |
| N | No. | |
| SORT | Specifies whether the index is sorted in ascending order. | |
| Y | Yes. | |
| N | No. | |
| COMPRESSION | Specify whether or not to use compression. | |
| Y | Yes. | |
| N | No. | |
| A | Advanced. | |
| blank | Not specified. This is the default. | |
| Compression length | Specify the compression length. | |
14:15:26 ***** P R E D I C T ***** 2017-08-11
- Modify Field -
Field ID ........ IDENTITY Modified 2017-08-11 at 14:15
File ID ......... XYZ-OTI by XYZ
Index segment attributes in XYZ-ORA1
PCTFREE ........ 12
PCTUSED ........ 2
INITRANS ....... 33
Tablespace ..... TAB
LOGGING .......* F File system like
* Additional attributes ..* S Associations ..* N |
| Index segment attributes | ||
|---|---|---|
| PCTFREE |
If an integer from 1 - 99 is specified here, the clause
|
|
| PCTUSED |
If an integer from 1 - 99 is specified here, the clause
|
|
| INITRANS |
If a value from 1 - 255 is entered here, the clause
|
|
| Tablespace | If a tablespace name is
entered here, the clause TABLESPACE name is
generated in the CREATE TABLE statement. This name
represents the tablespace in which the table will be created.
|
|
| LOGGING | Specify whether or not to
use the LOGGING clause in a CREATE
TABLE or ALTER TABLE statement.
|
|
| Y | Yes. | |
| N | No. | |
| F | File system like. | |
| blank | Not specified. This is the default. | |
14:17:52 ***** P R E D I C T ***** 2017-08-11
- Modify Field -
Field ID ........ IDENTITY Modified 2017-08-11 at 14:15
File ID ......... XYZ-OTI by XYZ
Index storage attributes in XYZ-ORA1
INITIAL ............. Unit .*
NEXT ................ Unit .*
MAXSIZE ............. Unit .* (-1 for unlimited)
OPTIMAL ............. Unit .* (-1 for null)
MINEXTENTS ..........
MAXEXTENTS .......... (-1 for unlimited)
PCTINCREASE .........
FREELISTS ........... 1
FREELIST GROUPS ..... 3
BUFFERPOOL .........* D Default
FLASH_CACHE ........* D Default
* Additional attributes ..* S Associations ..* N |
| Index storage attributes | ||
|---|---|---|
If specified, the values
below are used in the STORAGE clause generated with
the CREATE TABLE statement. All of the values below
must be specified as integers.
|
||
| INITIAL | The size of the first extent allocated when the object is created - the original amount of space allocated to the object. A value for Unit has to be applied in addition: | |
| K | Kilobyte. | |
| M | Megabyte. | |
| G | Gigabyte. | |
| T | Terabyte. | |
| P | Petabyte. | |
| E | Exabyte. | |
| NEXT | The size of every subsequent extent to be allocated. A value for Unit has to be applied in addition. Possible values for Unit are described under INITIAL. | |
| MAXSIZE | The MAXSIZE
clause lets you specify the maximum size of the storage element.
|
|
| OPTIMAL | Specifies an optimal size in bytes for a rollback segment. | |
| MINEXTENTS | The total number of extents to be allocated when the segment is created. | |
| MAXEXTENTS | The total number of extents, including the first, which can ever be allocated. | |
| PCTINCREASE | The percent by which each NEXT extent will grow over the last extent allocated. | |
| FREELISTS | The number of process free lists used to administer the free data blocks. | |
| FREELISTS GROUPS | Magnitude of the set of free lists. | |
| BUFFERPOOL | Determines the configuration of the buffer cache. | |
| D | Default | |
| K | Keep | |
| R | Recycle | |
| blank | not specified | |
| FLASH_CACHE | Defines the configuration of a second tier of buffer cache on flash disks. | |
| D | Default | |
| K | Keep | |
| N | None | |
| blank | not specified | |
For a partitioning key and partitioned index, the following can be defined depending on whether they are hash- or range-partitioned.
Note:
The data displayed in this screen depend on the values
selected in the Partitioning key field of the
DBMS
Extensions screen.
16:03:24 ***** P R E D I C T ***** 2017-08-17
- Modify Field -
Field ID ........ XYZ_OT_INDEX Modified 2017-08-17 at 16:02
File ID ......... XYZ-OTI by XYZ
Database ........ XYZ-ORA1
---------------------- Range partitioning key definitions ---------------------
Partition 1
Name ......
Literal ... Zoom: N
More attributes
Segment ............... N (Y/N)
Storage ............... N (Y/N)
Partition 2
Name ......
Literal ... Zoom: N
More attributes
Segment ............... N (Y/N)
Storage ............... N (Y/N)
* Additional attributes ..* S Associations ..* N * Scroll to .. 1 |
| Attributes | |
|---|---|
| Name | The partition name. |
| Literal | The literal name. |
| Segment | Specifies the Segment attributes of the partition. |
| Storage | Specifies the Storage attributes of the partition. |
16:10:45 ***** P R E D I C T ***** 2017-08-17
- Modify Field -
Field ID ........ XYZ_OT_INDEX Modified 2017-08-17 at 16:02
File ID ......... XYZ-OTI by XYZ
Database ........ XYZ-ORA1
---------------------- Hash partitioning key definitions ----------------------
Partition 1
Name ................
Tablespace ..........
COMPRESSION ........* (not specified)
Compression length ..
Partition 2
Name ................
Tablespace ..........
COMPRESSION ........* (not specified)
Compression length ..
* Additional attributes ..* S Associations ..* N * Scroll to .. 1 |
| Parameter | Description | |
|---|---|---|
| Name | The partition name. | |
| Tablespace | The tablespace name. | |
| COMPRESSION | Specify whether or not to use compression. | |
| Y | Yes. | |
| N | No. | |
| A | Advanced. | |
| blank | Not specified. This is the default. | |
| Compression length | Specify the compression length. | |
This additional attribute is only applicable for fields in
Sybase tables with Null value option set to R and Null default option set to Y.
Adabas D tables, DB2 tables, Informix and Oracle tables with Null value option set to R or U and Null default option set to Y.
13:09:33 ***** P R E D I C T ***** 2007-05-31
- Modify Field -
Field ID ........ TESTFIELD Modified 2007-05-31 at 13:09
File ID ......... HNO-YT by HNO
Ty L Field ID F Cs Length Occ D U DB N Df NAT-l
*- - -------------------------------- *- * -------- ----- * * -- * *- -----
1 TESTFIELD A B 10.0 AA R Y
Default name .............
Default expression ......<
>
|
| Attribute | |
|---|---|
| Default name | The default specified here is used in the CREATE TABLE
statement. Sybase naming conventions apply. See
Naming
Conventions for SQL Objects.
Note: |
| Default expression | An SQL expression can be specified between the angled brackets. This expression determines the default value, for example a constant or function. If specified, this value is always used by the function Generate CREATE statement. |
Depending on the field definition, up to four constraint names can be specified.
13:35:45 ***** P R E D I C T ***** 2007-05-31
- Modify Field -
Field ID ........ TESTFIELD Modified 2007-05-31 at 09:34
File ID ......... HNO-YT by HNO
Ty L Field ID F Cs Length Occ D U DB N Df NAT-l
*- - -------------------------------- *- * -------- ----- * * -- * *- -----
1 TESTFIELD A B 10.0 P U AA R Y
Attributes Constraint name
Check constraint
Primary key
Unique
Not null
|
| Attributes | |
|---|---|
| Check constraint | Constraint name in the respective SQL system for the fact that a linked verification of status S exists. |
| Primary key | Constraint name for the fact that the field is a primary key. |
| Unique | Constraint name for the fact that a unique constraint exists (indicated with U in column Unique option of the field object in Predict). |
| Null/Not null | Constraint name for the fact that the Null or Not null default option is set to Y. |
These additional attributes are only applicable for fields in DB2 or Oracle tables.
The following additional attributes are only applicable for fields of type
QN (Row ID) or
a numeric field.
15:56:16 ***** P R E D I C T ***** 2009-05-31
- Modify Field -
Field ID ........ XYZ_AC Added 2009-05-31 at 15:56
File ID ......... XYZ-DB2 by XYZ
Ty L Field ID F Cs Length Occ D U DB N Df NAT-l
*- - -------------------------------- *- * -------- ----- * * -- * *- -----
QN 1 XYZ_AC A 40.0 U AB R
Identity ............. (Y,N)
Identity definition in <Default Server>
Generated .........* A Always
Start value ........
Increment value ....
Cache ..............
Cycle .............. (Y,N)
No minvalue ........ (Y,N) Min value ..
No maxvalue ........ (Y,N) Max value ..
Order .............. (Y,N)
* Additional attributes ..* S Associations ..* N |
| Attributes | ||
|---|---|---|
| Identity | Specifies whether the column is an identity column for the table. Valid values: | |
| Y | Yes | |
| N | No | |
| Generated | ||
| Indicates whether DB2 or Oracle generates values for the column. Valid values: | ||
| A | Always | |
| D | By default | |
| blank | None | |
| Start with limit | The first generated value will be the highest/lowest existing value +/- increment value | |
| Start value | Specifies the first value for the identity column. | |
| Increment value | Specifies the interval between consecutive values of the identity column. | |
| Cache | Specifies whether to keep preallocated values in memory. | |
| Cycle | Specifies that values continue to be generated for this column after the maximum or minimum value has been reached. | |
| Min value | Specifies the numeric constant that is the minimum value that is generated for this identity column. | |
| No minvalue | Specifies for DB2 tables whether or not a minimum end point of the range of values for the identity column has been set. | |
| Max value | Specifies the numeric constant that is the maximum value that is generated for this identity column. | |
| No maxvalue | Specifies for DB2 tables whether or not a maximum end point of the range of values for the identity column has been set. | |
| Order | Specifies whether the sequence numbers must be generated in order of request. Valid values: | |
| Y | Order | |
| N | No order | |
| blank | Not specified | |
The following additional attributes are only applicable for fields of type
TS (Timestamp)
14:16:40 ***** P R E D I C T ***** 2009-07-31
- Modify Field -
Field ID ........ EL_TS Added 2009-02-13 at 08:56
File ID ......... HEB-D Modified 2009-06-04 at 14:14
Ty L Field ID F Cs Length Occ D U DB N Df NAT-l
*- - -------------------------------- *- * -------- ----- * * -- * *- -----
1 EL_TS TS AJ U
Change log ............. N (Y,N)
Change log definition in DADB29
Generated ...........* A Always
* Additional attributes ..* S Associations ..* N |
| Attributes | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Change log |
|
||||||||
| Generated |
|
||||||||
The following topics are covered:
This additional attribute is only applicable for Adabas fields with format A, AV or LO. The option No Blank Compression controls that trailing blanks are suppressed when a value is stored.
16:12:31 ***** P R E D I C T ***** 2007-05-31
- Add a Field -
Field ID ........ HNO_A Added 2007-05-31 at 16:11
File ID ......... HNO-ADA by HNO
Ty L Field ID F Cs Length Occ D U DB N Df NAT-l
*- - -------------------------------- *- * -------- ----- * * -- * *- -----
1 HNO_A A 10.0 AA N
Platform compatibilities
High order first ..... (Y)
PF option ............ (Y)
No Blank Compression . (Y)
Additional attributes ..* S Associations ..* N |
The following topics are covered:
These additional attributes are applicable for DB2 and Oracle table fields with format TS.
17:42:38 ***** P R E D I C T ***** 2011-05-31
- Modify Field -
Field ID ........ HNO_D2T_TS Added 2011-05-31 at 17:41
File ID ......... HNO-D2 by HNO
Ty L Field ID F Cs Length Occ D U DB N Df NAT-l
*- - -------------------------------- *- * -------- ----- * * -- * *- -----
1 HNO_D2T_TS TS N AA U N
Base extensions
Fractional of seconds .* 12
Time zone .............. (Y/N)
Additional attributes ..* S Associations ..* N |
| Attributes | |
|---|---|
| Fractional of seconds | A timestamp value can include a precision of fractional seconds in the range from 0 to 12 (Oracle 0-9). For DB2, if no value is entered, the default value 6 is taken. |
| Time zone | Provides information on the time difference in hours and minutes between the local time and Coordinated Universal Time (UTC). Adds an additional time zone offset value to the local timestamp value in the format +HH:MM (ahead of UTC) or -HH:MM (behind UTC). |
This additional attribute is applicable for DB2 LOB fields.
17:42:38 ***** P R E D I C T ***** 2011-05-31
- Modify Field -
Field ID ........ HNO_LOB_D2 Added 2011-05-31 at 17:41
File ID ......... HNO-D2-LOB by HNO
Ty L Field ID F Cs Length Occ D U DB N Df NAT-l
*- - -------------------------------- *- * -------- ----- * * -- * *- -----
1 HNO_LOB_D2 LO S 1.0M AA U
Base extensions
Inline length .......... 8000
Additional attributes ..* S Associations ..* N |
| Attributes | |
|---|---|
| Inline length | For BLOB, CLOB and DBCLOB columns. Specifies the maximum number of bytes that are stored in the base table space for the column. Must be between 0 and 32680 for a BLOB or CLOB column and between 0 and 16340 for a DBCLOB column.. |
These additional attributes are applicable for DB2 table fields with formats A, AL and AV.
12:41:28 ***** P R E D I C T ***** 2015-06-30
- Modify Field -
Field ID ........ EL_GEN_EXPR Modified 2015-06-11 at 13:17
File ID ......... XYZ-DB2_API by XYZ
Ty L Field ID F Cs Length Occ D U DB N Df NAT-l
*- - -------------------------------- *- * -------- ----- * * -- * *- -----
1 EL_GEN_EXPR A 4.0 AA U
Base extensions
Generated expression ..* PN PACKAGE_NAME
* Additional attributes ..* S Associations ..* N |
| Attributes | |||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Generated expression |
|
||||||||||||||||||||||||||||
The field option Period specifies whether the value of the end column is included or excluded in the period BUSINESS_TIME.
This option can be used only for fields named BUSINESS_TIME in files of type D and MT.
19:32:52 ***** P R E D I C T ***** 2020-07-02
- Modify Field -
Field ID ........ BUSINESS_TIME Modified 2020-03-11 at 11:08
File ID ......... HEB-DB_V12 by HEB
Ty L Field ID F Cs Length Occ D U DB N Df NAT-l
*- - -------------------------------- *- * -------- ----- * * -- * *- -----
SP 1 BUSINESS_TIME AF
Base extensions
Generated expression ..* (none)
Period ................* I Inclusive
* Additional attributes ..* S Associations ..* N |
| Attributes | ||
|---|---|---|
| Period | Specifies whether the value of the end column is included or excluded in the period BUSINESS_TIME. | |
| I | Inclusive | |
| E | Exclusive | |