DDL Reserved Words

The mcocomp DDL compiler recognizes reserved words that have operational meaning and consequently cannot be used in the schema definition as class or field names. (Please see the SQL Reserved Words page for a list of reserved words for the SQL compiler.)

The following are reserved words recognized by the DDL compiler:

abs	acos	add	all	and
any	as	asc	ascending	asin
atan	atomic	autoid	avg	between
bigint	binary	bit	blob	boolean
by	calculator	cascade	case_insensitive	cast
ceil	char	checkpoint	class	collate
compact	constraint	cos	count	create
database	date	datetime	decimal	declare
delete	delete_all	desc	descending	direct
distinct	distrib	distributed	domain	double
drop	escape	event	except	exists
exp	float	float	floor	for
foreign	from	group	hash	having
history	ignore_case	in	index	inner
insert	int	integer	intersect	into
is	join	key	left	length
like	limit	list	local	log
longint	longvarbinary	longvarchar	lower	max
min	minus	natural	nchar	new
nonatomic	nonunique	not	now	nstring
null	numeric	OID	oid	on
optional	or	order	outer	packed
persistent	primary	real	ref	reference
references	right	select	sequences	set
signed	sin	smallint	some	sqrt
string	struct	substr	sum	sysdate
table	tan	time	time	timestamp
tinyint	to	transient	tree	TTL_clock_time
TTL_count	unicode	union	unique	unsigned
unsigned	update	upper	userdef	using
values	varbinary	varchar	vector	voluntary
wchar	where	wstring	FALSE	TRUE