Since SAS 7, most SAS
names can be up to 32 characters long.
SAS/ACCESS Interface to Sybase
IQ supports table names and column names that contain up to 32 characters.
If DBMS column names are longer than 32 characters, they are truncated
to 32 characters. If truncating a column name would result in identical
names, SAS generates a unique name by replacing the last character
with a number. DBMS table names must be 32 characters or less because
SAS does not truncate a longer name. If you already have a table name
that is greater than 32 characters, it is recommended that you create
a table view. For more information, see
SAS Names and Support for DBMS Names.
The PRESERVE_COL_NAMES=
and PRESERVE_TAB_NAMES= options determine how
SAS/ACCESS Interface
to Sybase IQ handles case sensitivity. (For information about these
options, see
Overview: LIBNAME Statement for Relational Databases .) Sybase IQ is not case sensitive, so all names default
to lowercase.
Sybase IQ objects include
tables, views, and columns. They follow these naming conventions.
-
A name must be from 1 to 128 characters
long.
-
A name must begin with a letter
(A through Z), underscore (_), at sign (@), dollar sign ($), or pound
sign (#).
-
Names are not case sensitive. For
example, CUSTOMER and
Customer are the same,
but object names are converted to lowercase when they are stored in
the Sybase IQ database. However, if you enclose a name in quotation
marks, it is case sensitive.
-
A name cannot be a Sybase IQ reserved
word, such as WHERE or VIEW.
-
A name cannot be the same as another
Sybase IQ object that has the same type.
For more information,
see your
Sybase IQ Reference Manual.