Previous Topic: Status (STS)Next Topic: Time (TME)

Understanding Your Data Model › Using Fields › Defining Function Fields as REF Fields › ISO Time (TM#)

ISO Time (TM#)

The following table contains the default characteristics of the TM# field.


Field Type Attribute

Shipped Default Value

Default Override

Field Details Override

Device Field Override

Implementation name

System data type

External length

Internal length

Decimal places

xxTA

Alpha

6.0

8

N

-

N

N

-

N

Y

N

N

-

N

N

N

N

-

N

LHS text (Column headings)

RHS text

Field name

Time

N

Y

Y

Y

Y

Y

Keyboard shift

Allow lowercase

Mandatory fill

Valid system name

Mod10/11 check

DYN

-

-

-

-

N

-

Y

-

Y

N

-

Y

-

Y

N

-

N

-

N

Check condition

Translate values

*NONE

-

N

-

Y

-

Y

-

Field exit option

Edit codes: Input

Output

Report

Y

T

T

T

Y

Y

Y

Y

N

Y

Y

Y

Y

Y

Y

-

The TM# type is one of two field types used for fields that represent times. For compatibility with standards set by the International Standards Organization (ISO), it is recommended that you use TM# for your time fields. Since the TM# field type meets ISO standards, time fields of this type are interpreted correctly for SQL and Query Manager.

CA 2E automatically generates code to validate TM# fields.

ISO time is stored internally in HH.MM.SS format and externally as HHMMSS.

Note: A value of 00.00.00 on the physical file represents zero, not a valid time.

CA 2E generates ISO times as the i OS Time type with TIMFMT(*ISO) and assimilates i OS Time fields as type TM#.

Examples of TM# fields include: