KB#00506-List of reserved words for the 1.1 32-bit ODBC Driver and 1.0 16-bit ODBC Driver

Title:

List of reserved words for the 1.1 32-bit ODBC Driver and 1.0 16-bit ODBC Driver

Description:

Following is an alphabetized list of the reserved words for the BASIS 1.0 16-bit and 1.1 32-bit ODBC Drivers. As these words are reserved, they cannot be used when naming tables or columns in a Data Dictionary. Most of these are pretty explanatory and would never be used as a table or column name, but a couple of them are common enough to cause problems. For example, the DESC keyword is used in SQL to set the sorting order to descending. However, it's not uncommon for a column to be named DESC as a shorthand for DESCRIPTION. If this is the case, SQL queries involving that column will not execute properly. 

ALL 
AND 
AS 
ASC 
AVG 
BETWEEN 
BIGINT 
BYTE 
CHAR 
CHARACTER 
COUNT 
CREATE 
DATE 
DECIMAL 
DELETE 
DESC 
DISTINCT 
DOUBLE 
DROP 
FALSE 
FLOAT 
FOREIGN 
FROM 
GROUPBY 
HAVING 
INDEX 
INSERT 
INTEGER 
INTO 
IS 
KEY 
LIKE 
MAX 
MIN 
NOT 
NULL 
NUMERIC 
ON 
OR 
ORDERBY 
PRIMARY 
REAL 
SELECT 
SET 
SMALLINT 
SUM 
TABLE 
TEMPORARY 
TRUE 
UNION 
UNIQUE 
UNKNOWN 
UNSIGNED 
UPDATE 
VALUES 
VARCHAR 
VARYING 
VIEW 
WHERE

Last Modified: 02/13/1998 Product: BASIS ODBC Driver Operating System: Windows

BASIS structures five components of their technology into the BBx Generations.