E Obsolete Database Utilities

Creating a new data item

CREATE ITEM {
Ident, [count] type [ (format) ];
...
}

Ident is the item name, count is the optional subitem count, type is the item type, format is an optional format number.

If the statement is enclosed in curly braces, multiple items can be defined.

Item type is the same as defined by the schema processor and must be one of:

I, I2

Allow read access

I4, D

Allow read and write access

R4, S

Short REAL

R8, L

REAL

Xn

String, size specified by n must be even

The QUERY format number is composed by adding the various values, which are given after the plus sign.

Query format numbers

Bits	Field description	Field value	Description	add value
0	Item Protection	0	Item value may be changed in QUERY	0
		1	Item is write protected	1
1-2	Item type	0	default	0
		1	date type (days since 1972)	2
		2	Currency	4
		3	Undefined	6
3	Item spacing	0	default	0
		1	Comma every 3 digits	8
4-6	Post decimals	0	default	0
		1	FIXED 0	16
		2	FIXED 1	32
		3	FIXED 2	48
		...
		7	FIXED 6	112

For example:

  CREATE ITEM
    Call-Id, D (2);

  CREATE ITEM {
    Call-Id,   D;
    Call-Date, D (2);
    Call-Desc, 2X40;
  }