ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-8
Data Types
For more information, see the following documents:
Table, View, and Index Names
For table, view, and index names, specify CORE SQL identifiers. The NonStop ODBC
Server maps these identifiers to eight-character Guardian file names. Even though the
names are mapped, you refer to the object by its CORE SQL name when accessing it
using the NonStop ODBC Server.
Procedure Names
For procedure names, you specify CORE SQL identifiers. The NonStop ODBC Server
maps these identifiers to the names of Pathway server class programs. Even though
the names are mapped, you refer to the object by its CORE SQL name when
accessing it using the NonStop ODBC Server.
Column and Correlation Names
For column names and correlation names, you specify CORE SQL identifiers. Mapping
is not necessary, so you refer to the object by its CORE SQL name when accessing it
using the NonStop ODBC Server.
Data Types
When creating and manipulating objects and data items, you must specify CORE SQL
data types. Because CORE SQL and NonStop SQL/MP data types differ, the data
types or values you specify are converted to corresponding NonStop SQL/MP data
types.
Even if you are retrieving or manipulating data created with NonStop SQL/MP, you
must specify CORE SQL, not NonStop SQL/MP, data types and values.
This subsection summarizes NonStop ODBC Server support of CORE SQL data types.
Data type support falls in two categories:
•
Creating objects and data
•
Retrieving and manipulating NonStop SQL/MP objects and data
Note. If Safeguard is in effect for the system and the username is an alias, the NonStop
ODBC server always uses the alias name for the logon. If the username is not an alias, the
NonStop ODBC server uses the Guardian name for the logon. If Safeguard is not in effect, the
NonStop ODBC server always uses the Guardian name for the logon.
For Information About See
CORE SQL usernames X/Open CAE Specification
Name mapping Section 7, Managing Customized Catalogs
Guardian logon name Guardian User’s Guide