Book Contents
Master Index
SAS/ACCESS Software for Relational Databases: Reference
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
K
|
L
|
M
|
N
|
O
|
P
|
Q
|
R
|
S
|
T
|
U
|
V
|
W
|
D
data conversions
CA-OpenIngres, ACCESS procedure
CA-OpenIngres, DBLOAD procedure
CA-OpenIngres, LIBNAME statement
DB2 under OS/390, ACCESS procedure
DB2 under OS/390, DBLOAD procedure
DB2 under OS/390, LIBNAME statement
DB2 under UNIX and PC hosts, ACCESS procedure
DB2 under UNIX and PC hosts, DBLOAD procedure
DB2 under UNIX and PC hosts, LIBNAME statement
Informix, LIBNAME statement
Informix, SQL Pass-Through Facility
Oracle Rdb, ACCESS procedure
Oracle Rdb, DBLOAD procedure
ORACLE, ACCESS procedure
ORACLE, DBLOAD procedure
ORACLE, LIBNAME statement
SYBASE, ACCESS procedure
SYBASE, DBLOAD procedure
SYBASE, LIBNAME statement
Teradata, LIBNAME statement
DATA= option
PROC DB2UTIL statement
PROC DBLOAD statement
data security
data set options
CA-OpenIngres
DB2 under OS/390
DB2 under UNIX and PC hosts
DBMS data and
Informix
ODBC
OLE DB
ORACLE
"Data Set Options for Bulk Loading"
ORACLE
"Data Set Options: ORACLE Specifics"
Oracle Rdb
performance and
SYBASE
Teradata
data sets
SEE:
SAS data sets
DATA step views
data types
CA-OpenIngres
"CA-OpenIngres SQL Data Types"
CA-OpenIngres
"DBTYPE="
DB2 under OS/390
"DB2 Data Types"
DB2 under OS/390
"DBTYPE="
DB2 under UNIX and PC hosts
"DB2 Data Types"
DB2 under UNIX and PC hosts
"DBSASTYPE="
DB2 under UNIX and PC hosts
"DBTYPE="
Informix
"DBTYPE="
Informix
"Informix Data Types and SAS Representations and Formats"
ODBC
"DBSASTYPE="
ODBC
"DBTYPE="
ODBC
"ODBC Data Types"
OLE DB
"DBSASTYPE="
OLE DB
"DBTYPE="
OLE DB
"OLE DB Data Types"
ORACLE
"DBSASTYPE="
ORACLE
"DBTYPE="
ORACLE
"ORACLE7 Server Data Types"
Oracle Rdb
SYBASE
Teradata
"DBTYPE="
Teradata
"Maximizing Teradata Performance"
Teradata
"Teradata Data Types"
Database 2
SEE:
DB2 under UNIX and PC hosts
Database 2 under OS/390
SEE:
DB2 under OS/390
database administration
DATABASE= connection argument
DB2 under UNIX and PC hosts
Informix
Oracle Rdb
SYBASE
DATABASE= connection option
CA-OpenIngres
Informix
ODBC
SYBASE
DATABASE= option, DBLOAD procedure (ODBC)
DATABASE= statement, ACCESS procedure
CA-OpenIngres
DB2 under UNIX and PC hosts
Oracle Rdb
SYBASE
DATABASE= statement, DBLOAD procedure
CA-OpenIngres
DB2 under UNIX and PC hosts
Oracle Rdb
SYBASE
databases
DATASETS procedure
DATASRC= connection argument (DB2 under UNIX and PC hosts)
DATASRC= connection option
DB2 under UNIX and PC hosts
ODBC
"CONNECT Statement"
ODBC
"LIBNAME Statement: ODBC Specifics"
date data, Teradata
date informats and formats
CA-OpenIngres
DB2 under UNIX and PC hosts
in columns
Informix
ODBC
OLE DB
ORACLE
Teradata
datetime values
DB2 under OS/390
DB2 under UNIX and PC hosts
OLE DB
Oracle Rdb
DB= connection argument (Informix)
DB2 engine
DB2 under Microsoft Windows
SEE:
DB2 under UNIX and PC hosts
DB2 under OS/2
SEE:
DB2 under UNIX and PC hosts
DB2 under OS/390
access descriptors, creating
"ACCESS Procedure: DB2 Specifics"
access descriptors, creating
"ACCESS Procedure: DB2 Specifics"
ACCESS procedure
attachment facility
authorization IDs
connection restrictions
"ACCESS Procedure: DB2 Specifics"
connection restrictions
"SAS/ACCESS LIBNAME Statement: DB2 Specifics"
connections
"Information for the Database Administrator"
connections
"Maximizing DB2 Performance"
data conversions, ACCESS procedure
data conversions, DBLOAD procedure
data conversions, LIBNAME statement
data set options
data types
"DB2 Data Types"
data types
"DBTYPE="
database administrator information
DB2 engine
DB2UTIL procedure
DBLOAD procedure
debugging code
decpoint-value
default values
deleting data
Distributed Data Facility (DDF)
DRDA
"ACCESS Procedure: DB2 Specifics"
DRDA
"DBLOAD Procedure: DB2 Specifics"
DRDA
"Information for the Database Administrator"
inserting data
locks
"READ_LOCK_TYPE="
locks
"UPDATE_LOCK_TYPE="
modifying DB2 data
naming conventions
NULL values
"DB2 Data Types"
NULL values
"DBLOAD Procedure: DB2 Specifics"
NULL values
"DBNULL="
performance
plan specification
return codes
RRSAF
SAS/ACCESS LIBNAME statement
SAS system options
SQL Procedure Pass-Through Facility
subsystem name
"ACCESS Procedure: DB2 Specifics"
subsystem name
"DBLOAD Procedure: DB2 Specifics"
subsystem name
"SAS System Options and Settings for DB2"
subsystem name
"SAS System Options and Settings for DB2"
system catalogs
table location specification
"ACCESS Procedure: DB2 Specifics"
table location specification
"DBLOAD Procedure: DB2 Specifics"
table location specification
"IN="
table location specification
"LOCATION="
table location specification
"SAS System Options and Settings for DB2"
table specification
tables, modifying
update privileges
updating data
Versions 7 and 8
view descriptors, creating
DB2 under PC hosts
SEE:
DB2 under UNIX and PC hosts
DB2 under UNIX and PC hosts
ACCESS procedure
connections
cursor type
data conversions, ACCESS procedure
data conversions, DBLOAD procedure
data conversions, LIBNAME statement
data set options
data types
"DB2 Data Types"
data types
"DBSASTYPE="
data types
"DBTYPE="
date formats
DBLOAD procedure
indexes
isolation levels
"READ_ISOLATION_LEVEL="
isolation levels
"UPDATE_ISOLATION_LEVEL="
locks
"READ_LOCK_TYPE="
locks
"UPDATE_LOCK_TYPE="
naming conventions
NULL values
"DB2 Data Types"
NULL values
"DBNULL="
query time limits
rowset size
SAS/ACCESS LIBNAME statement
schemas
SQL Procedure Pass-Through Facility
Versions 7 and 8
DB2DBUG= system option
DB2DECPT= system option
DB2IN= system option
DB2PLAN= system option
DB2RRS= system option
DB2SSID= system option
DB2UPD= system option
DB2UTIL procedure
ERRLIMIT statement
example
EXIT statement
MAPTO statement
modifying DB2 data
RESET statement
SQL statement
statements and options
UPDATE statement
WHERE statement
DBCOMMIT= data set option
DBCONDITION= data set option
DBCONINIT= option, SAS/ACCESS LIBNAME statement
DBCONTERM= option, SAS/ACCESS LIBNAME statement
DBCREATE_TABLE_OPTS data set option
DBDATABASE environment variable
DBFORCE= data set option
OLE DB
ORACLE
DBGEN= option, SAS/ACCESS LIBNAME statement
DBGEN_NAME= data set option
DBINDEX= data set option
CA-OpenIngres
DB2 under UNIX and PC hosts
ODBC
OLE DB
ORACLE
Teradata
DBINDEX= option, SAS/ACCESS LIBNAME statement
CA-OpenIngres
DB2 under UNIX and PC hosts
ODBC
ORACLE
Teradata
DBKEY= data set option
DBLABEL= data set option
DBLIBINIT= option, SAS/ACCESS LIBNAME statement
DBLIBTERM= option, SAS/ACCESS LIBNAME statement
DBLINK= data set option
ORACLE
SYBASE
DBLINK= option, SAS/ACCESS LIBNAME statement
ORACLE
SYBASE
DBLOAD procedure
ACCDESC= statement
case sensitivity
COMMIT= statement
creating DBMS tables
DELETE statement
details
ERRLIMIT= statement
examples, running
invoking
LABEL statement
LIMIT= statement
LIST statement
LOAD statement
naming limits
NULLS statement
options
PROC DBLOAD statement
QUIT statement
RENAME statement
RESET statement
SQL statement
statements
syntax
TABLE= statement
terminating
TYPE statement
WHERE statement
DBLOAD procedure, CA-OpenIngres
data conversions
statements
DBLOAD procedure, DB2 under OS/390
data conversions
statements
DBLOAD procedure, DB2 under UNIX and PC hosts
data conversions
examples
statements
DBLOAD procedure, ODBC
example
statements
DBLOAD procedure, ORACLE
data conversions
examples
statements
DBLOAD procedure, Oracle Rdb
data conversions
statements
DBLOAD procedure, SYBASE
data conversions
example
statements
DBMAX_TEXT= data set option
DBMAX_TEXT= option, SAS/ACCESS LIBNAME statement
DBMS commit statements
DBMS connections
controlling
customizing connect and disconnect exits
prompting for options
DBMS data
combining with SAS data
"Creating SAS Data Sets from DBMS Data"
combining with SAS data
"Joining DBMS and SAS Data"
creating SAS data sets from
data set options and
deleting
examples
inserting
joining DBMS and SAS data
"Creating SAS Data Sets from DBMS Data"
joining DBMS and SAS data
"Joining DBMS and SAS Data"
joining from various sources
librefs for
ordering
PRINT procedure with
reading
"Information for the Database Administrator"
reading
"Information for the Database Administrator"
reading
"Reading and Updating Data with the SQL Procedure"
reading
"Reading and Updating Data with the SQL Procedure"
retrieving with Pass-Through queries
SAS/ACCESS LIBNAME statement and
SQL Pass-Through Facility with
SQL procedure with
subsetting
"DBCONDITION="
subsetting
"Selecting and Combining Data"
subsetting
"WHERE"
UPDATE statement with
updating
"Information for the Database Administrator"
updating
"Information for the Database Administrator"
updating
"Reading and Updating Data with the SQL Procedure"
updating
"Reading and Updating Data with the SQL Procedure"
updating
"Using the SQL Procedure with DBMS Data"
updating SAS data files with
updating with MODIFY statement
Version 6 procedures with
DBMS= option
PROC CV2ODBC statement
PROC DBLOAD statement
DBMS= option, PROC ACCESS statement
DBMS table names
DBMS tables
accessing, on different nodes or databases
appending data to
"Choosing a SAS/ACCESS Feature"
appending data to
"DBLOAD Procedure Syntax"
appending data to
"Using Other SAS Procedures with DBMS Data"
column data types, changing
commits
creating
"Choosing a SAS/ACCESS Feature"
creating
"Information for the Database Administrator"
creating
"LOAD"
creating with SQL procedure
deleting
deleting rows
"Choosing a SAS/ACCESS Feature"
deleting rows
"Reading and Updating Data with the SQL Procedure"
dropping variables
error limits for
inserting rows
"Choosing a SAS/ACCESS Feature"
inserting rows
"Reading and Updating Data with the SQL Procedure"
limiting observations in
listing
listing variable information
loading
locking
means calculation
name specification
querying a single table
querying multiple tables
ranking data
reading
reading data from multiple tables
specifying, for access descriptors
subsetting data
table privileges
updating rows
viewing contents of
viewing list of
DBNULL= data set option
CA-OpenIngres
DB2 under OS/390
DB2 under UNIX and PC hosts
Informix
ODBC
OLE DB
ORACLE
Teradata
DBPROMPT= data set option
ORACLE
DBPROMPT= option, SAS/ACCESS LIBNAME statement
ORACLE
Teradata
DBSASTYPE= data set option
DB2 under UNIX and PC hosts
ODBC
OLE DB
ORACLE
DBTYPE= data set option
CA-OpenIngres
DB2 under OS/390
DB2 under UNIX and PC hosts
Informix
ODBC
OLE DB
ORACLE
Teradata
DDF (Distributed Data Facility)
debugging code, DB2 under OS/390
DEFER= option, SAS/ACCESS LIBNAME statement
ODBC
DELETE statement, DBLOAD procedure
CA-OpenIngres
DELETE_MULT_ROWS= option, SAS/ACCESS LIBNAME statement
ODBC
OLE DB
descriptor files
SEE:
view descriptors
DFLANG= system option
Direct SQL Join feature
DIRECT_SQL= option, SAS/ACCESS LIBNAME statement
DISCONNECT statement, SQL Pass-Through Facility
Distributed Data Facility (DDF)
Distributed Relational Database Architecture (DRDA)
DQUOTE= option, PROC SQL statement
DRDA (Distributed Relational Database Architecture)
DROP statement, ACCESS procedure
DS= connection argument (DB2 under UNIX and PC hosts)
DSN= connection argument (DB2 under UNIX and PC hosts)
DSN= connection option, ODBC
DSN= option, DBLOAD procedure (ODBC)
DSN statement, CV2ODBC procedure
DSN= statement, DB2 under UNIX and PC hosts
ACCESS procedure
DBLOAD procedure
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
K
|
L
|
M
|
N
|
O
|
P
|
Q
|
R
|
S
|
T
|
U
|
V
|
W
|
