Template:DEFINE FIELD attributes: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Created page with "<!-- This page may be automatically regenerated SO DO NOT MANUALLY EDIT IT --> <table> <caption>Field attributes</caption> <tr> <th>Attribute </th> <th>Abbreviation <...")
 
mNo edit summary
Line 7: Line 7:
<caption>Field attributes</caption>
<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
<tr> <th><var>AT-MOST-ONE

Revision as of 21:52, 22 May 2015

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