Since SAS 7, most SAS
names can be up to 32 characters long.
SAS/ACCESS Interface to HP
Neoview 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.
The PRESERVE_COL_NAMES=
and PRESERVE_TAB_NAMES= options determine how
SAS/ACCESS Interface
to HP Neoview handles case sensitivity. (For information about these
options, see
Overview: LIBNAME Statement for Relational Databases .) HP Neoview is not case sensitive by default, and all
names default to uppercase.
HP Neoview objects include
tables, views, and columns. Follow these naming conventions:
-
A name must be from 1 to 128 characters
long.
-
A name must begin with a letter
(A through Z, or a through z). However, if the name appears within
double quotation marks, it can start with any character.
-
A name cannot begin with an underscore
(_). Leading underscores are reserved for system objects.
-
Names are not case sensitive. For
example,
CUSTOMER and
Customer are
the same, but object names are converted to uppercase when they are
stored in the HP Neoview database. However, if you enclose a name
in quotation marks, it is case sensitive.
-
A name cannot be a reserved word
in HP Neoview, such as WHERE or VIEW.
-
A name cannot be the same as another
HP Neoview object that has the same type.
For more information,
see your
HP Neoview SQL Reference Manual.