Template:DEFINE FIELD attributes: Difference between revisions

Latest revision as of 23:45, 22 May 2017

Field attributes
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

@@ Line 7: / Line 7: @@
 <caption>Field attributes</caption>
-<tr>  <th>Attribute </th> <th>Abbreviation </th> <th>Default</th> </tr>
+<tr class="head">  <th>Attribute </th> <th>Abbreviation </th> <th>Default</th> </tr>
 <tr> <th><var>AT-MOST-ONE
@@ Line 27: / Line 27: @@
 </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
 <p>NON-DEFERRABLE</p>