Previous Page | Next Page

SAS/ACCESS Interface to HP Neoview

LIBNAME Statement Specifics for HP Neoview


Overview

This section describes the LIBNAME statement that SAS/ACCESS Interface to HP Neoview supports and includes examples. For details about this feature, see Overview of the LIBNAME Statement for Relational Databases.

Here is the LIBNAME statement syntax for accessing HP Neoview.

LIBNAME libref neoview <connection-options> <LIBNAME-options>;

Arguments

libref

specifies any SAS name that serves as an alias to associate SAS with a database, schema, server, or group of tables and views.

neoview

specifies the SAS/ACCESS engine name for the HP Neoview interface.

connection-options

provide connection information and control how SAS manages the timing and concurrence of the connection to the DBMS. When you use the LIBNAME statement on UNIX or Microsoft Windows, you can connect to HP Neoview Database Connectivity Service (NDCS) by connecting a client to a data source. Specify only one of the following methods for each connection because each is mutually exclusive.

  • SERVER=, SCHEMA=, PORT=, USER=, PASSWORD=

  • DSN=, USER=, PORT=

Here is how these options are defined.

SERVER=<'>server-name<'>

specifies the server name or IP address of the HP Neoview server to which you want to connect. This server accesses the database that contains the tables and views that you want to access. If the server name contains spaces or nonalphanumeric characters, you must enclose it in quotation marks.

SCHEMA=<'>schema-name<'>

specifies the name of a schema. When you use it with SERVER= or PORT=, it is passed directly as a connection option to the database. When you use it with DSN=, it qualifies SQL statements as a LIBNAME option. You can also use it as a data set option.

PORT=port

specifies the port number that is used to connect to the specified HP Neoview server. If you do not specify a port, the default is 18650.

USER=<'>Neoview-user-name<'>

specifies the HP Neoview user name (also called the user ID) that you use to connect to your database. If the user name contains spaces or nonalphanumeric characters, you must enclose it in quotation marks.

PASSWORD=<'>Neoview-password<'>

specifies the password that is associated with your HP Neoview user name. If the password contains spaces or nonalphanumeric characters, you must enclose it in quotation marks. You can also specify PASSWORD= with the PWD=, PASS=, and PW= aliases.

DSN=<'>Neoview-data-source<'>

specifies the configured HP Neoview ODBC data source to which you want to connect. Use this option if you have existing HP Neoview ODBC data sources that are configured on your client. This method requires additional setup--either through the ODBC Administrator control panel on Windows platforms or through the MXODSN file or a similarly named configuration file on UNIX platforms. So it is recommended that you use this connection method only if you have existing, functioning data sources that have been defined.

LIBNAME-options

define how SAS processes DBMS objects. Some LIBNAME options can enhance performance, while others determine locking or naming behavior. The following table describes the LIBNAME options for SAS/ACCESS Interface to HP Neoview, with the applicable default values. For more detail about these options, see LIBNAME Statement Syntax for Relational Databases.

SAS/ACCESS LIBNAME Options for HP Neoview
Option Default Value
ACCESS=
none
AUTHDOMAIN=
none
AUTOCOMMIT=
operation-specific
BL_NUM_ROW_SEPS=
1
BULKEXTRACT=
NO
CONNECTION=
UNIQUE
CONNECTION_GROUP=
none
CONNECTION_TIMEOUT=
0
DBCOMMIT=
1000 (inserting) or 0 (updating)
DBCONINIT=
none
DBCONTERM=
none
DBCREATE_TABLE_OPTS=
none
DBGEN_NAME=
DBMS
DBINDEX=
YES
DBLIBINIT=
none
DBLIBTERM=
none
DBMAX_TEXT=
1024
DBMSTEMP=
NO
DBNULLKEYS=
YES
DBPROMPT=
NO
DBSLICEPARM=
THREADED_APPS,3
DEFER=
NO
DELETE_MULT_ROWS=

DIRECT_EXE=
none
DIRECT_SQL=
YES
IGNORE_ READ_ONLY_COLUMNS=
NO
INSERTBUFF=
automatically calculated based on row length
MULTI_DATASRC_OPT=
none
PRESERVE_COL_NAMES=
see Naming Conventions for HP Neoview
PRESERVE_TAB_NAMES=
see Naming Conventions for HP Neoview
QUALIFIER=
none
QUERY_TIMEOUT=
0
QUOTE_CHAR=
none
READBUFF=
automatically calculated based on row length
REREAD_EXPOSURE=
NO
SCHEMA=
none
SPOOL=
YES
SQL_FUNCTIONS=
none
SQL_FUNCTIONS_COPY=
none
STRINGDATES=
NO
TRACE=
NO
TRACEFILE=
none
UPDATE_MULT_ROWS=

UTILCONN_TRANSIENT=
NO


HP Neoview LIBNAME Statement Examples

In this example, SERVER=, DATABASE=, USER=, and PASSWORD= are connection options.

libname mydblib neoview server=ndcs1 schema=USR user=neo1 password=neopwd1;

In the next example, DSN=, USER=, and PASSWORD= are connection options.

libname mydblib neoview DSN=TDM_Default_DataSource user=neo1 password=neopwd1;

Previous Page | Next Page | Top of Page