Access
To display or modify the additional information of a logical property, click the More information tab in the Create/Modify a logical property dialog box.
The Edit, Input Options and Help document name details can be taken from the data type (where applicable), or from the original conceptual property, if one exists. In this case the details are not modifiable. The SQL constraint is non-modifiable if any value other than *ENV is obtained from the data type or original conceptual property.
Data entry
SQL constraint
SQL constraint associated with the columns of the generated SQL tables.
Values available:
*ENV |
The value is the same as the one defined in the environment attributes. |
NULL |
The column can take the NULL value. This value will be used if you insert a line into the table without specifying a value for the column. |
NOT NULL |
The column cannot take the NULL value. You cannot insert a line into the table without specifying a value for the column. |
NOT NULL WITH DEFAULT |
The column cannot take the NULL value. The type's default value will be used if you insert a line into the table without specifying a value for the column. |
NULL WITH DEFAULT |
The column can take the NULL value. However, the type's default value will be used if you insert a line into the table without specifying a value for the column. |
Default: *ENV.
Ass. graphical object
Graphical object which will be suggested by default when placing the property into a VADELIA–type program window.
Help
Name of the document containing the property's on-line help.
This field is protected when it comes from the data type or from the original conceptual property.
Depending on the documentation tool, the syntax is:
DSPF field-level help |
: |
DSPF Name / Format Name, or Format Name. |
OFFICE/400 field-level help |
: |
Label Document Folder. |
UIM field-level help |
: |
Help_Name Panel_Group_Name. |
Optional entry.
Important note: Field-level help is only valid for programs generated on the AS/400.
Column headings
Description of the column headings used by the Screen Layout Manager or Report Layout Manager in "Column" type display formats.
You can define three columns headings, with a maximum length of 20 characters each.
Optional entry.
Edit word
Edit word defining a display mask for a numeric field when the edit code list is insufficient.
Click the corresponding radio button to define an edit word.
Length: 60 characters maximum.
This field is protected when it comes from the data type or from the original conceptual property.
This field cannot be filled in if an edit code was selected.
Restrictions relative to the edit word:
one zero maximum is allowed,
one asterisk maximum is allowed,
single quotes are not allowed,
any other character is accepted but ignored,
the length of the edit word must be equal to that of the logical property,
this length is computed by counting the possible spaces, asterisk and zero.
Optional entry.
Click here for more details on edit words.
Edit code
IBM-defined keyword, used for editing numeric fields with a specific display mask (example: deletion of zeros on the left).
Click the corresponding radio button to define an edit code.
This field is protected when it comes from the data type or from the original conceptual property.
Select an edit code in the list box.
This field cannot be filled in if an edit word was specified.
Click here for more details on edit codes .
Layout description: Line
Description of the property used by the Adelia Screen Layout Manager or Report layout manager in Line- or Mixed-type display formats.
Length: 30 characters maximum.
Default: *DEFAULT; the property description is used.
Optional entry.
Layout description: Column
Description of the column heading used by the Adelia Screen or Report layout manager in "Column" –type display formats.
Length: 20 characters maximum.
Default: *DEFAULT; the first column heading description is used.
Optional entry.
Radio buttons
Keyboard options
A keyboard option is used to control certain functions at the keyboard level.
These options are protected when they come from the data type or from the original conceptual property.
The following options (defined by IBM) are available:
- KS codes: keyboard attributes:
KSA |
alphanumeric plus lowercases, |
KSD |
numeric from 0 to 9 without decimal positions, |
KSE |
non-combined DBCS, |
KSG |
grahical DBCS, |
KSI |
inhibit keyboard entry, |
KSJ |
double-byte only DBCS, |
KSM |
numeric from 0 to 9 with sign, point, comma, blank, |
KSN |
numeric, |
KSO |
combined DBCS, |
KSS |
numeric with sign on the right, |
KSW |
Katakana code page, |
KSX |
from A to Z with comma, point and dash (uppercases only), |
KSY |
numeric with edit code or word, |
None |
no keyboard attribute. |
- Other codes:
AB |
blanks allowed, |
LC |
lowercases allowed, |
VN |
valid field name, |
VNE |
valid field extended name, |
RAB |
right-adjust with blank fill, |
RAZ |
right-adjust with zero fill, |
None |
no other keyboard option. |
The VN and VNE options are mutually exclusive.
The RAB and RAZ options are mutually exclusive.
The KSE, KSG, KSJ and KSO options are incompatible with the VN, VNE and RAZ options.
The KSG and KSS options are incompatible with the LC option.
One option maximum can be selected among:
KSA, KSD, KSE, KSG, KSI, KSS, KSM, KSN, KSO, KSS, KSW, KSX and KSY.
For an alphanumeric property, only the following options are available:
KSA, KSD, KSE, KSG, KSI, KSJ, KSM, KSN, KSO, KSX, KSW, AB, RAB, RAZ, LC, VN and VNE.
For a numeric property, only the following options are available:
KSD, KSI, KSN, KSS, KSY, RAB and RAZ.
For further details about keyboard options, see the IBM manual "Data Description Specifications Reference".