Page History
...
- Field types 1.1.2 Alpha, 1.1.7 Packed, and 1.1.8 Signedcan be used in all partitions.
- Field types 1.1.11 Date, 1.1.12 Time, 1.1.13 DateTime, 1.1.14 Binary, 1.1.15 VarBinary, 1.1.3 String, 1.1.4 NVarChar, 1.1.6 NChar, 1.1.5 Char, 1.1.9 Integer, 1.1.10 Float, 1.1.17 BLOB, 1.1.18 CLOB and 1.1.19 Boolean must be used in an RDMLX Enabled Partition . Refer to RDML and RDMLX Partition Concepts in the Administrator Guide for details about these partition differences.
- Packed, Signed and Integers allow Edit Codes and Edit Words. No other field types support Edit Codes or Edit Words.
- Keyboard Shift Blanks is the only valid value for Binary, VarBinary, Date, Time, DateTime, Integer, Float, NVarChar, NChar, BLOB, and Boolean.
- In an RDMLX partition, a field that is defined by a reference field must not have different attributes from the reference field, regardless of the *IMPREFFLDNOPROP flag in the system definitions.
- ASQN attribute (see Common Attributes in 1.2.17 Input Attributes) will be enabled by default for new fields of types Date, Time, DateTime, Binary, VarBinary, BLOB, and CLOB.
...
- LANSA has implemented strong typing for all field types.
- Alpha, String, and Char are all classed as String types and are valid for LANSA arguments of type 'A'.
- Packed, Signed, Float, and Integer are classed as Numbers and are valid for LANSA arguments of type 'N'.
- All other types like Date, DateTime, and BLOB are classed as their own type and are not valid for either a type 'A', or type 'N'.
- Use of Hex 00 is not supported by LANSA in Alpha, String, Char, NVarChar, and NChar fields. The behavior will vary depending on what platform you are on and the database you write the data to. The use of hex 00 in Alpha working fields where overlays are used may have a valid purpose in RDML on IBM i, but it is up to you to ensure that the LANSA behavior meets the needs of the application on all platforms and databases where the application may run.
- Field types have a default property, usually. Value, and additional properties as required. For a Date field #MyDate, the following examples all have identical meaning:
...
- Rather than the default property .Value, fields of type BLOB and CLOB have a default property called .FileName clearly indicates that changing the field's " value " is actually changing its default property, which is a file name property.
- Fields that are SQL-nullable can be tested with *IS or *ISNOT *SQLNULL, and also have an intrinsic property called .IsSqlNull. This can be used to determine the current state of the field. For example:
...