Defining Additional Attributes of Fields
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:
3GL Specification
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 |
| R |
When COBOL copy code is generated, the
statement JUSTIFIED RIGHT is added for this field. Any data written to this
field is then right-justified.
|
| L |
Data will be left-justified. Default. |
|
| Synchronized |
| Applicable to fields of format
I, F or B and length 1, 2, 4 or 8.
|
| S |
When Assembler, COBOL or PL/I copy/include
code or a record layout is generated, this field can be aligned on a half-word,
word, or double-word boundary (speeding up arithmetic operations). This affects
format buffer generation and the offsets of the fields in the record buffer.
Slack-bytes are inserted into the record buffer by the assembler or compiler
but they are built into any format buffer by Predict using space characters
X.
|
|
| Initialize with |
| Determines the initial value for
generation. To be used instead of the standard value (zeros for a numeric
field, blanks for an alphanumeric field).
|
| S |
blank |
| L |
low value |
| H |
high value |
| Z |
zero |
| Q |
quote |
| F |
Fill with string specified in the parameter
Init. value (mandatory). For example: if X is specified and the field length is
4, XXXX will be used for initialization.
|
| blank |
Field will be initialized with the string
specified in the field Init. value. If no Init. value is specified, no
initialization is performed.
|
|
| 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:
-
if Format=B, hexadecimal values can be specified directly.
Example: F0
-
if Format=A, hexadecimal values must be preceded by uppercase X
or H and be enclosed in single quotes. Example: X'F0' or H'F0'
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).
|
Condition Name
and Value
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 |
| Figurative constant. Valid
values:
|
| S |
blank |
| L |
low value |
| H |
high value |
| Z |
zero |
| Q |
quote |
| F |
Fill with string specified in the parameter
Condition. value. For example: if X is specified an the field length is 4, XXXX
is used as condition value.
|
| blank |
The string specified in the field Condition
value is used.
|
|
| 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.
|
Field Name Synonyms
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.
|
Old Mode Synonyms
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:
|
Adabas Security and Edit mask
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
|
|
The Adabas edit mask to be used for the field. Determines how
numeric fields are to be edited.
|
| Valid values for Edit mask rules
used in the COBOL programming language:
|
|
E1...E15.
Edit mask is supported for compatibility reasons and for
documentation purposes only.
See the section Format Buffer Syntax in the
Adabas Command Reference documentation for more
information.
|
| Valid values for Date-Time Edit
masks:
|
| D |
Date. |
| T |
Time. |
| DT |
Datetime. |
| TS |
Timestamp. |
| NT |
Natural time. |
| ND |
Natural date. |
| UT |
Unix time. |
| XTS |
Unix timestamp. |
| blank |
None. |
|
In Predict, fields with format D by default use Natural date
(NATDATE) and fields with format T by default use Natural time (NATTIME) Edit
masks.
The different Date-Time Edit masks require different minimum
numeric field lengths.
Detailed information is given in section Date-Time
Edit Mask Reference of the Adabas Mainframe
documentation.
|
|
| 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.
|
DBMS Extensions
Applicable only to DB2 fields of type D or MT and to Adabas fields of
type A.
The following screens 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 ......... HEB-D_HASH_PART by HEB
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 |
The following screens 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 |
| 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:
-
The data type of the column must be CHAR(8).
-
The subtype of the column must be SBCS.
-
The column must be defined with the NOT NULL and WITH DEFAULT
clauses.
-
No field procedures, check constraints, or referential
constraints are defined on the column.
-
An edit procedure is not defined on the table.
Refer to your DB2 documentation for further
details.
|
| Partitioning |
| Indicates for each
implementation of a table in a 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:
This option can only be set for DB2 fields of type D and MT
using the Default Table Attributes function in the
Default DB2
Attributes screen.
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.
|
|
Field Procedure
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.
|
Derived Field Expression
> > + 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 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 Definition - DB2
Index Default Definition / Defaults Values of Using-
and Free-Block
Index fields (descriptor type D, F or P) in a file of type D (DB2
table), are defined in the screen below.
11:28:09 ***** P R E D I C T ***** 2006-04-20
- Modify Field -
Field ID ........ INDEX Added 2006-04-20 at 11:28
File ID ......... HNO-DB2 by HNO
Index default definition in <Default Server>
Index name ......... HNO-INDEX Number of partitions: 3
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 .* R not null
Default values of using- and free-block
VSAM catalog name ..
Storagespace ......* SYSDEFLT
Primary alloc ...... 1
Secondary alloc..... 2
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 |
| 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..
|
|
| Bufferpool |
The buffer pool associated with the index. |
| Close option |
| Y |
The data sets supporting this index are
closed when nobody uses the index.
|
|
| Copy |
| Indicates whether the copy
utility is allowed for the index.
|
| Y |
Full image or concurrent copies
allowed.
|
| N |
Full image or concurrent copies not
allowed.
|
|
| 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 |
| Specifies whether an index
supports forward scans only or reverse scans of the index also.
|
| Y |
Reverse scans allowed. |
| N |
Reverse scans not allowed. This is the
default.
|
|
| Padded |
| Specifies how varying-length
string columns are to be stored in the index.
|
| Y |
Padded. |
| N |
Not padded. |
| blank |
Not specified. |
|
| UQ
where not null
|
| Null value option. Specifies
whether a null value is allowed for a unique index. Valid values:
|
| U |
Null allowed. Any two null values are taken
to be unequal. If the key is a single column, that column can contain any
number of null values, though its other values must be unique.
|
| R |
Not null. Any two null values are taken to be
equal. For example, if the key is a single column, that column can contain no
more than one null value.
|
| blank |
Determined by gener. Null value option is set
via default server settings in Predict.
|
|
| Compress |
| Specifies whether compression
for index data will be used.
|
| Y |
Compression is used. |
| N |
No compression is used. This is the
default.
|
|
| 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 |
| Y |
The DB2-defined data sets are to be erased
(filled with nulls) when the index is dropped.
|
| A value specified in this field
is stored only if the attribute Storage group has been specified.
|
|
| 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 |
Only relevant in a data sharing
environment. Specifies what pages of the table space or partition are written
to the group buffer pool.
Leave this field blank or enter:
|
| C |
Changed. Only pages that have been changed
are written to the group buffer pool.
|
| A |
All pages are written. |
| N |
No pages are written to the group buffer
pool.
|
|
Partition definition
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).
15:37:23 ***** P R E D I C T ***** 2007-05-31
- Modify Field -
Field ID ........ INDEX Modified 2007-05-31 at 15:37
File ID ......... HNO-DB2 by HNO
SQL Server ...... <Default Server>
---------------------------- Partition definition -----------------------------
Partition 1
Value ..... 1 Zoom: N
VSAM catalog name .....
Storagespace .........* HNO-SC
Primary allocation .... GBPCACHE ........* Default
Secondary allocation .. Free pages .......
Erase option .......... N (Y/N) Percentage free ..
Partition 2
Value ..... 2 Zoom: N
VSAM catalog name .....
Storagespace .........* HNO-SC-1
Primary allocation .... GBPCACHE ........* Default
Secondary allocation .. Free pages .......
Erase option .......... N (Y/N) Percentage free ..
* Additional attributes ..* S 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:
No checking is performed here.
|
All other attributes are described above.
Default value
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:
For Sybase, a default is an object in its own right. For other
SQL systems, a default value is specified in the CREATE TABLE statement (not
null with default default_expression). For Informix no default name is
allowed.
|
| 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.
|
Constraint name
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.
|
Identity definition / Change log
These additional attributes are only applicable for fields in DB2
tables.
Identity definition
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 ........ HNO_AC Added 2009-05-31 at 15:56
File ID ......... HNO-DB2 by HNO
Ty L Field ID F Cs Length Occ D U DB N Df NAT-l
*- - -------------------------------- *- * -------- ----- * * -- * *- -----
QN 1 HNO_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 generates
values for the column. Valid values:
|
| A |
Always |
| D |
By default |
| blank |
None |
|
| 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 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 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 |
|
Change log
The following additional attributes are only applicable for fields of
type
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 |
| Specifies whether DB2 generates
a value for the column for each new row when the row is inserted and/or for any
row in which a column is updated. Valid values:
|
| Y |
Yes |
| N |
No |
|
| Generated |
| Indicates whether DB2 generates
values for the column. Valid values:
|
| A |
Always |
| D |
By default |
| blank |
None |
|
Platform Compatibilities
The following topics are
covered:
No Blank Compression
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 |
Base Extensions
The following topics are
covered:
Fractional of Seconds and Time Zone
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).
|
Inline Length
This additional attributes 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..
|
Generated Expression
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 |
|
For fields of DB2 tables (field types A, AL and AV) you can
specify an
as-generated-expression-clause.
The value provided in Generated expression is the expression
that is evaluated by DB2 when generating the value of the field. Valid
values:
|
| DC |
Data change operation. Equivalent DB2
expression: DATA CHANGE OPERATION |
| CC |
Client accounting. Equivalent DB2 expression:
CURRENT CLIENT_ACCTNG |
| CN |
Client application name. Equivalent DB2
expression: CURRENT CLIENT_APPLNAM |
| CT |
Client correlation token. Equivalent DB2
expression: CURRENT CLIENT_CORR_TOKEN |
| CU |
Client user ID. Equivalent DB2 expression:
CURRENT CLIENT_USERID |
| CW |
Client workstation name. Equivalent DB2
expression: CURRENT CLIENT_WRKSTNNAME |
| CS |
Client server. Equivalent DB2 expression:
CURRENT SERVER |
| CI |
SQL ID. Equivalent DB2 expression:
CURRENT SQLID |
| SU |
Session user. Equivalent DB2 expression:
SESSION_USER |
| PN |
Package name. Equivalent DB2 expression:
SYSIBM.PACKAGE_NAME |
| PS |
Package schema. Equivalent DB2 expression:
SYSIBM.PACKAGE_SCHEMA |
| PV |
Package version. Equivalent DB2 expression:
SYSIBM.PACKAGE_VERSION |
| blank |
None. |
|
