Book Contents		Master Index

O

ODBC

AS/400, data source configuration

AS/400, LIBNAME statement

AS/400, short alias names

AS/400, SQL Pass-Through views "PROC SQL Pass-Through Views"

AS/400, SQL Pass-Through views "PROC SQL Pass-Through Views"

connections

cursor "CURSOR_TYPE="

cursor "KEYSET_SIZE="

data set options

data sources

data sources, AS/400

data sources, MS SQL server

data types "DBSASTYPE="

data types "DBTYPE="

data types "ODBC Data Types"

date and time formats "Examples"

date and time formats "SASDATEFMT="

DBLOAD procedure

engine connection options

examples

indexes

isolation levels "READ_ISOLATION_LEVEL="

isolation levels "UPDATE_ISOLATION_LEVEL="

locks "READ_LOCK_TYPE="

locks "UPDATE_LOCK_TYPE="

Microsoft Excel data sources

MS SQL server "LIBNAME Statement: ODBC Specifics"

MS SQL server "PROC SQL Pass-Through Views"

MS SQL server "PROC SQL Pass-Through Views"

MS SQL server "PROC SQL Pass-Through Views"

naming conventions

NULL values

overview

PROC SQL Pass-Through views

qualifiers

queries "QUERY_TIMEOUT="

queries "Special ODBC Queries"

rowset size

SAS/ACCESS LIBNAME statement

schemas

SQL Procedure Pass-Through Facility

VALIDVARNAME= option and

Versions 7 and 8

OLAP data, OLE DB for

examples

SQL Pass-Through Facility and

OLE DB

command time-out

connecting directly with data provider

connecting to

connecting with OLE DB Services

connection arguments

connections

cursor

data set options

data types "DBSASTYPE="

data types "DBTYPE="

data types "OLE DB Data Types"

date informats and formats "SASDATEFMT="

date informats and formats "SASDATEINFMT="

datetime formats

engine connection options

indexes

isolation levels "READ_ISOLATION_LEVEL="

isolation levels "UPDATE_ISOLATION_LEVEL="

locks "READ_LOCK_TYPE="

locks "UPDATE_LOCK_TYPE="

MS SQL server "CONNECT Statement"

MS SQL server "LIBNAME Statement: OLE DB Specifics"

naming conventions

NULL values

OLAP data

ORACLE, accessing OLE DB data in

qualifiers

queries

rowset size

SAS/ACCESS LIBNAME statement

schemas

SQL Procedure Pass-Through Facility

truncation of data

Version 8

OLEDB_SERVICES= connection argument

OLEDB_SERVICES= option, SAS/ACCESS LIBNAME statement

open database connectivity

SEE: ODBC

OpenVMS hosts, supported features

ORACLE

ACCESS procedure

accessing OLE DB data in

bulk loading options

connections

data conversions, ACCESS procedure

data conversions, DBLOAD procedure

data conversions, LIBNAME statement

data set options "Data Set Options for Bulk Loading"

data set options "Data Set Options: ORACLE Specifics"

data types "DBSASTYPE="

data types "DBTYPE="

data types "ORACLE7 Server Data Types"

date formats

DBLOAD procedure

default values

engine connection options "DBPROMPT="

engine connection options "LIBNAME Statement: ORACLE Specifics"

hints

indexes

isolation levels "READ_ISOLATION_LEVEL="

isolation levels "UPDATE_ISOLATION_LEVEL="

locks "READ_LOCK_TYPE="

locks "UPDATE_LOCK_TYPE="

naming conventions

NULL values "DBNULL="

NULL values "ORACLE7 Server Data Types"

remote database access

rows, deleting

rows, inserting

rows, loading

rows, reading

rows, updating

SAS/ACCESS LIBNAME statement

schemas

SQL Procedure Pass-Through Facility

SQL*Loader

truncating data

Versions 7 and 8

Oracle Rdb

ACCESS procedure

connection arguments

connections

constraints at commit time

data conversions, ACCESS procedure

data conversions, DBLOAD procedure

data set options

data types

DBLOAD procedure

naming conventions

NULL values

READONLY access

SQL Procedure Pass-Through Facility

update access

Versions 7 and 8

ORACLEPW= statement, ACCESS procedure

ORACLE_73_OR_ABOVE= option, SAS/ACCESS LIBNAME statement

ORAPW= connection argument

ORAPW= statement, DBLOAD procedure

ORHINTS= data set option, ORACLE

OUT= option, PROC ACCESS statement

OWNER= data set option

ODBC

OLE DB