Access
To display or modify the additional information of a property, click the More Information tab of the Create/Modify a conceptual property dialog box.
The Edit information, as well as the Keyboard options and the Help document name, can be the ones of the possible data type. In this case, this information cannot be modified. The SQL constraint cannot be modified if a value other than *ENV comes from the data type or from the 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.
Help
Name of the document which contains the property's on-line help.
Depending on the documentation tool, the help field complies with one of the following syntax format:
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
Column heading descriptions used by the Screen or Report layout manager, in the "Column"-type display formats.
Length: 30 characters maximum.
A heading can be filled-in while the others remain blank.
Optional entry.
Edit word
Edit word defining a display mask for a numeric field when the edit code list is insufficient.
To define an edit word, click the corresponding radio button.
This field cannot be informed if an "Edit code" was selected.
The edit word is forbidden for an alphanumeric property, and is optional for a numeric property.
Length: 60 characters maximum.
Restrictions relative to the edit word:
-
the length of the edit word must be equal to that of the property;
this length is computed by counting the possible spaces, asterisk and zero;
only one zero is allowed;
only one asterisk is allowed;
single quotes are not allowed;
any other character is accepted but ignored.
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).
To define an edit code, click the corresponding radio button.
This field cannot be informed if an "Edit word" was specified.
Click here for more details on edit codes.
Radio buttons
Keyboard options
A keyboard option is used to control certain functions at the keyboard level.
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 |
graphical 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 extended field 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 KSJ options are incompatible with the LC option.
One option maximum can be selected among:
KSA, KSD, KSE, KSG, KSI, KSJ, 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 more details on keyboard options, see the "Data Description Specifications Reference" IBM manual.