Template:DEFINE FIELD attributes: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
m (hand-enter DATETIME info) |
||
| Line 27: | Line 27: | ||
</td> <td>NON-CODED</td> </tr> | </td> <td>NON-CODED</td> </tr> | ||
<tr> <th><var>DATETIME</var></th> <td>DT</td> | |||
<td>Data format YYYYMMDDHHMMSSXXXXXX <br>(the nearest millionth of a second)</td> </tr> | |||
<tr> <th><var>DEFERRABLE | <tr> <th><var>DEFERRABLE | ||
<p>NON-DEFERRABLE</p> | <p>NON-DEFERRABLE</p> | ||
Latest revision as of 23:45, 22 May 2017
| Attribute | Abbreviation | Default |
|---|---|---|
| AT-MOST-ONE
REPEATABLE | ONE
REPT | REPT (except in 1NF files) |
| BINARY | BIN | Not a binary field |
| BINARY-LARGE-OBJECT | BLOB | Not binary large object |
| CHARACTER-LARGE-OBJECT | CLOB | Not character large object |
| CODED
NON-CODED | COD
NCOD | NON-CODED |
| DATETIME | DT | Data format YYYYMMDDHHMMSSXXXXXX (the nearest millionth of a second) |
| DEFERRABLE
NON-DEFERRABLE | DEF
NDEF | DEFERRABLE |
| FEW-VALUED
MANY-VALUED | FV
MV | MANY-VALUED |
| FLOAT | FL | Not a floating point field |
| FRV (for-each-value)
NON-FRV |
-- NFRV | NON-FRV |
|
KEY NON-KEY |
-- NKEY |
NON-KEY |
| LENGTH m | LEN | No preallocated length |
| LEVEL k | LVL | No level |
| LRESERVE | LRES | 15 |
| NRESERVE | NRES | 15 |
| NUMERIC RANGE
NON-RANGE | RANGE, NR
NNR | NON-RANGE |
| OCCURS n | OCC | No preallocated occurrences |
| ORDERED
NON-ORDERED | ORD
NON-ORD | Non-ordered field |
| ORDERED CHARACTER | ORD CHAR | -- |
| ORDERED NUMERIC | ORD NUM | -- |
| SPLITPCT | SPLT | 50 |
| IMMED | IMM | 1 |
| PAD character | -- | PAD X'00' |
| STRING
BINARY | STR
BIN | STRING |
| UPDATE IN PLACE
UPDATE AT END | UP
UE | UPDATE IN PLACE |
| VISIBLE
INVISIBLE | VIS
INV | VISIBLE |
| UNIQUE
NON-UNIQUE | UNIQ
NUNIQ | NON-UNIQUE |