Portable SQL keywords restricted by the IMS Universal JDBC drivers

If you use any of the following SQL keywords as a name for a PCB, segment, or field, your JDBC application will receive an error when it attempts an SQL query. Instead, use the aliasing feature of the IMS Enterprise Suite Explorer for Development. These keywords are not case-sensitive.

The keywords shown in the following table are reserved SQL keywords.

ABORT to CROSS	CURRENT to IS	JOIN to REAL	REFERENCES to WORK
ABORT	CURRENT	JOIN	REFERENCES
ANALYZE	CURSOR	LAST	RESET
AND	DECIMAL	LEADING	REVOKE
ALL	DECLARE	LEFT	RIGHT
ALLOCATE	DEFAULT	LIKE	ROLLBACK
ALTER	DELETE	LISTEN	ROW
AND	DESC	LOAD	ROWS
ANY	DISTINCT	LOCAL	SELECT
ARE	DO	LOCK	SET
AS	DOUBLE	MAX	SETOF
ASC	DROP	MIN	SHOW
ASSERTION	END	MOVE	SMALLINT
AT	EXECUTE	NAMES	SUBSTRING
AVG	EXISTS	NATIONAL	SUM
BEGIN	EXPLAIN	NATURAL	TABLE
BETWEEN	EXTRACT	NCHAR	TO
BINARY	EXTEND	NEW	TRAILING
BIT	FALSE	NO	TRANSACTION
BOOLEAN	FETCH	NONE	TRIM
BOTH	FIRST	NOT	TRUE
BY	FLOAT	NOTIFY	UNION
CASCADE	FOR	NULL	UNIQUE
CAST	FOREIGN	NUMERIC	UNLISTEN
CHAR	FROM	ON	UNTIL
CHARACTER	FULL	ONLY	UPDATE
CHECK	GRANT	OR	USER
CLOSE	GROUP	ORDER	USING
CLUSTER	HAVING	OUTER	VACUUM
COLLATE	IN	PARTIAL	VALUES
COLUMN	INNER	POSITION	VARCHAR
COMMIT	INSERT	PRECISON	VARYING
CONSTRAINT	INT	PRIMARY	VERBOSE
COPY	INTERVAL	PRIVILEGES	VIEW
COUNT	INTERVAL	PROCEDURE	WHERE
CREATE	INTO	PUBLIC	WITH
CROSS	IS	REAL	WORK