Virtual and Alter Data Item Types
In This Appendix
This appendix lists Databridge-specific data item types for VIRTUAL and ALTER declarations.
Additional Databridge Data Item Types.
Databridge supplies several data item types in addition to the regular DMSII types that you can use when you specify a VIRTUAL or ALTER in the DBGenFormat parameter file.
The additional TIME, NUMERIC, and ALPHA data item types are grouped throughout this section by the following formats:
- TIME_ n formats
- Combined date and time formats
- Specially-defined formats
The Databridge Client also provides a way to change the data item type. For more information, refer to the Databridge Client Administrator's Guide for more information about how you can use the various date, time, and combined date/time formats available with the Databridge Client.
TIME_n Formats
The following TIME_ n data types are all one-word (6 byte) data items corresponding to the TIME ( n ) function, as follows:
| Type | Description |
|---|---|
| TIME_1 | Time of day in sixtieths of a second |
| TIME_6 | Timestamp |
| TIME_7 | Day of week, date, time |
| TIME_11 | Time of day in 2.4 microseconds |
| TIME_60 | Time zone, Julian date, time of day in hundredths of a second |
Combined Date and Time Formats
The following NUMBER and ALPHA declarations allow you to specify a date and time format rather than a size, as follows:
NUMBER (datetimeformat)
or
ALPHA (datetimeformat)
where datetimeformat is one of the following:
| Format | Description |
|---|---|
| YYDDD | ALPHA (5) or NUMBER (5) with a two-digit year YY and with days DDD where DDD is a number between 1–366 for Julian dates |
| HHMMSS | ALPHA (6) or NUMBER (6) time of day |
| YYMMDD MMDDYY DDMMYY | ALPHA (6) or NUMBER (6) with two-digit YY (1900–1999) |
| YYYYDDD | ALPHA (7) or NUMBER (7) with four-digit year YYYY and with days DDD where DDD is a number between 1–366 for Julian dates |
| YYMMMDD | ALPHA (7) with a two-digit year YY (1900–1999) and a three-character month abbreviation Months are abbreviated JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, and DEC. |
| YYYYMMDD MMDDYYYY DDMMYYYY | ALPHA (8) or NUMBER (8) with four-digit year YYYY |
| YYYYMMMDD | ALPHA (9) with a four-digit year YYYY and a three-character month abbreviation Months are abbreviated JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, and DEC. |
| HHMMSSYYDDD YYDDDHHMMSS | ALPHA (11) or NUMBER (11) with two-digit year YY (1900–1999), days DDD where DDD is a number between 1–366 for Julian dates, and a six-digit time |
| YYMMDDHHMMSS MMDDYYHHMMSS DDMMYYHHMMSS | ALPHA (12) or NUMBER (12) with two-digit year YY representing dates in both the 20th and 21st centuries, followed by a six-digit time |
| HHMMSSYYMMDD HHMMSSMMDDYY HHMMSSDDMMYY | ALPHA (12) or NUMBER (12) with two-digit year YY (1900–1999) preceded by a sixdigit time |
| YYYYDDDHHMMSS | ALPHA (13) or NUMBER (13) with four-digit year YYYY and with days DDD where DDD is a number between 1–366 for Julian dates followed by a six-digit time |
| HHMMSSYYYYDDD | ALPHA (13) or NUMBER (13) with four-digit year YYYY and with days DDD where DDD is a number between 1–366 for Julian dates preceded by a six-digit time |
| YYYYMMDDHHMMSS MMDDYYYYHHMMSS DDMMYYYYHHMMSS | ALPHA (14) or NUMBER (14) with four-digit year followed by a six-digit time |
| HHMMSSYYYYMMDD HHMMSSMMDDYYYY HHMMSSDDMMYYYY | ALPHA (14) or NUMBER (14) with four-digit year preceded by a six-digit time |
Specially-defined Formats
The following formats allow you to represent NUMBER, ALPHA, and integer types in predetermined ways, as follows:
| Type | Description |
|---|---|
| DAYSCOUNT (n) | Number of days since 1/1/1900 as a NUMBER (n) The DAYSCOUNT ALTER triggers the Databridge Client to generate a Miser date, which is a dms_subtype of 1. The Miser date is fixed at 01.01.1900 and cannot be changed. To modify and use a custom base year, the dms_subtype must be 3, which is a LINC date. |
| LINCDATE (n) | Number of days since 1/1/1957 as an ALPHA (n) |
| NUMERIC ALPHA (n) | An ALPHA data item of n bytes containing a numeric value in alphanumeric EBCDIC form For example, a NUMERIC ALPHA (4) having the value 123 would contain "0123", that is, 4"F0F1F2F3". |
| BITS (n) | A field of n bits containing a binary integer value This type is similar to a DASDL FIELD (n). |
| IMAGE (n) | An IMAGE data item of n bytes containing binary data (such as a scanned image or bitmap) rather than EBCDIC characters |
| REAL | A one-word floating point value |
| REAL (n, m) | A one-word binary integer with optional scaling |
| NUMBER (Sn, m) | A NUMBER data item with an optional sign digit followed by n 4-bit digits with optional scaling |
| FIELD (booleanlist) | A field of named bits (Booleans) NOTE: The format applies to ALTER declarations only. |
| GROUP (dataitems) | A group of related data items that could be called collectively by the group name rather than by the individual item names NOTE: The format applies to ALTER declarations only. |