Reserved Keywords and Symbols

The list of CONNX reserved keywords and symbols begins below. If one of these keywords or symbols is used as a database object or field name, you must select the Use Quoted Delimiters option in the CONNX Data Dictionary Manager window.

Note: If a reserved keyword is used as a field or table name in a database object, CONNX automatically appends the names with the characters _col.

Important: When the Use Quoted Delimiters option is selected, the keyword or symbol must be surrounded by quotation marks.

Reserved Symbols and Reserved Keywords beginning with Symbols

-	/	<
(	;	<=
)	?	<>
*	@@IDENTITY	=
--*(	{	>
--*)	\|\|	>=
*=	}
,	+

"A" Reserved Keywords

abs	adabas_reuse	any	authorization
acos	adabas_uisize	arraysearch	autocommit
adabas	adabas_uiunit	as	autocounter
adabas_dssize	add	asc	avedevmean
adabas_dsunit	all	ascii	avedevmedian
adabas_maxisn	all~cols	asin	avg
adabas_nisize	alter	atan	avg_distinct
adabas_niunit	and	atan2

"B" Reserved Keywords

begin	bibdata	bin	bit_length
begintrans	bibxref	binary	block
between	bigint	bit	by

"C" Reserved Keywords

call	cnxforcechar	connxext	cot
cascade	cnxmemory	connxlength	count
case	cnxname	connxnullableindex	count_distinct
cast	cnxpreference	connxnullspace	create
catalog	cnxrpc	connxoffset	curdate
ceiling	cnxsleep	connxoption	current
char	coefvarpct	connxprecision	current_catalog
char_length	coefvarpctp	connxprefix	current_date
character	column	connxscale	current_schema
character_length	commit	connxtype	current_time
chr	concat	constraint	current_timestamp
cluster	connx_hash	convert	curtime
cnxforcebinary	connx_version	cos

"D" Reserved Keywords

database	datepart	dayofweek	decode	description
date	datetime	dayofyear	default	difference
dateadd	day	dbid	degrees	distinct
datediff	dayname	dec	delete	double
datename	dayofmonth	decimal	desc	drop

"E" through "J" Reserved Keywords

else	float	group	index
encrypt	floor	having	inner
end	fn	hex	insert
execute	for	host	int
exists	foreign	hour	integer
exp	from	if	into
extract	getcursorname	ifempty	is
file	getdate	ifnull	is not
first	getvmsdate	ilike	join
fixed	grant	in

"K" through "L" Reserved Keywords

key	last	locate	longvarbinary
kthlargest	lcase	log	lower
kthsmallest	left	log10	ltrim
kurtosis	length	long
kurtosisp	like	longnvarchar

"M" through "N" Reserved Keywords

max	minute	multimodalcount	nclob	ntusername
median	mod	multimodaloccur	netrics_match	null
microsoft	mode	national	not	number
middle	month	natural	now	numeric
min	monthname	nchar	nowait	nvarchar

"O" through "P" Reserved Keywords

octet_length	order	pow
odbc	outer	power
of	output	precision
oj	password	primary
on	pi	privileges
option	port	product
or	position	public

"Q" through "R" Reserved Keywords

quantile	range	replace	rmserrorp
quarter	real	restrict	rollback
quartile1	references	reverse	rotate
quartile3	remoteport	revoke	round
radians	remoteserver	right	rowcount
rand	repeat	rmserror	rtrim

"SA" through "SP" Reserved Keywords

schema	setrealtimedatabuffer	skewness	sortfirst
second	shortname	skewnessp	sortlast
select	sign	slike	sortmiddle
seqno	sin	smallint	soundex
set	size	some	space

"SQL_" Reserved Keywords

sql_binary	sql_integer	sql_timestamp	sql_tsi_quarter
sql_bit	sql_longvarbinary	sql_tinyint	sql_tsi_second
sql_char	sql_longvarchar	sql_tsi_day	sql_tsi_week
sql_date	sql_numeric	sql_tsi_frac_second	sql_tsi_year
sql_decimal	sql_real	sql_tsi_hour	sql_user_name
sql_double	sql_smallint	sql_tsi_minute	sql_varbinary
sql_float	sql_time	sql_tsi_month	sql_varchar

"SQ" through "SZ" Reserved Keywords

sqrt	strcmp	substring	suppression
stddev	stuff	sum	switch
stddevp	substr	sum_distinct

"T" through "U" Reserved Keywords

table	timestampadd	trimean	update
tablephysicallyexists	timestampdiff	truncate	upper
tan	tinyint	ucase	uqindex
then	to	union	use
time	tpadateofbirth	unique	user
timestamp	trim	unsigned

"V" through "Z" Reserved Keywords

values	variancep	virtual	with
varbinary	varying	week	work
varchar	vendor	when	xpusername
variance	view	where	year