| DB | Areas | X-idx | Tables | Sequences | <- progproc | progspec -> | HtmlDict 11 |
Programs in a system
| Area | Data |
|---|---|
| Dumpname | program |
| Label | Programs in a system |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 180 | act-time | X | Actual Time | decimal-1 | >>9.9 | 0 | ||
| 60 | date-written | X | Date written | date | 99/99/9999 | ? | ||
| 80 | est-time | X | Estimated Time | decimal-1 | >>9.9 | 0 | ||
| 170 | est-to-compl | X | Est. To Completion | decimal-1 | >>9.9 | 0 | ||
| 150 | gen-allow | X | Generate Allowed | logical | Yes/No | Yes | ||
| 210 | job-id | X | Job ID | integer | >>>>>9 | 0 | ||
| 190 | loc-cde | X | Loc Code | character | ! | |||
| 40 | prog-desc | X | Program desc | character [5] | x(50) | D: Program description | ||
| 20 | prog-name | X | Program | character | x(8) | D: Program name | ||
| 30 | prog-short-desc | X | Short desc | character | x(30) | D: Short description for the program | ||
| 21 | prog-ver-no | X | Program Ver No | decimal-2 | 9.99 | 1 | ||
| 160 | req-date | X | Request date | date | 99/99/9999 | ? | ||
| 200 | source-cde | X | Source Code | blob | x(8) | ? | ||
| 90 | stat-cde | X | Status Code | character | ! | |||
| 10 | sys-cde | X | System | character | x(3) | |||
| 120 | templ | X | Template | character | x(8) | |||
| 121 | templ-ver-no | X | Templ ver no | decimal-2 | 9.99 | 1 | ||
| 70 | type-cde | X | Program Type | character | ! | |||
| 130 | upd-date | X | Date Updated | date | 99/99/9999 | ? | ||
| 131 | upd-time | X | Update Time | integer | >>,>>9 | 0 | ||
| 140 | upd-user-id | X | Update By | character | x(8) | |||
| 100 | user-id | X | User ID | character | x(12) | D: User signon id | ||
| 50 | valid-opt | X | Valid Option | character | x(5) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| program | P U | prog-name (+) | character |
| prog-ver-no (-) | decimal | ||
| job-id | job-id (+) | integer | |
| prog-desc | prog-short-desc (+) | character | |
| sys-cde | sys-cde (+) | character | |
| prog-name (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| generated 3-3-2025 10:31 |