Book Contents		Master Index

C

CA-OpenIngres

ACCESS procedure

data conversions, ACCESS procedure

data conversions, DBLOAD procedure

data conversions, LIBNAME statement

data set options

data types "CA-OpenIngres SQL Data Types"

data types "DBTYPE="

date formats and informats

DBLOAD procedure

distributed CA-OpenIngres

indexes

INGOPTS= system option

locks

naming conventions

NULL values "CA-OpenIngres SQL Data Types"

NULL values "DBNULL="

SAS/ACCESS LIBNAME statement

schemas

SQL Procedure Pass-Through Facility

Versions 7 and 8

CA-OpenIngres Gateways

CA-OpenIngres/Net

CA-OpenIngres/Star

calculating statistics

case sensitivity

ACCESS procedure

DBLOAD procedure

SQL procedure and Pass-Through Facility

SYBASE

CELLPROP= option, LIBNAME statement (OLE DB)

Changes and Enhancements

SAS/ACCESS-DBMS product support

Version 7 and Version 8

character data

CA-OpenIngres

Informix

ORACLE

SYBASE

Teradata

charting data

column names

DBMS column names to SAS variable names

defaulting to SAS labels

resetting to defaults

SAS variable names to DBMS column names

variable labels as

columns

as indexes

changing formats for

creating with SQL procedure

data types, changing

data types, resetting

date formats in

dropping

listing

NULL values in "DBNULL="

NULL values in "NULLS"

performance and

renaming

renaming variables

resetting to defaults

selecting

selecting, for view descriptors

combining data

COMMAND_TIMEOUT= data set option, OLE DB

COMMAND_TIMEOUT= option, LIBNAME statement (OLE DB)

COMMIT= option, PROC DB2UTIL statement

COMMIT= statement, DBLOAD procedure

commit statements

COMPLETE= connection argument

DB2 under UNIX and PC hosts

OLE DB

COMPLETE= connection option

DB2 under UNIX and PC hosts

ODBC "CONNECT Statement"

ODBC "LIBNAME Statement: ODBC Specifics"

CONNECT statement, SQL Pass-Through Facility

CA-OpenIngres

DB2 under OS/390

DB2 under UNIX and PC hosts

Informix

ODBC

OLE DB

ORACLE

CONNECTION= option, SAS/ACCESS LIBNAME statement

DB2 under OS/390

ODBC

OLE DB

SYBASE

CONNECTION TO component, SQL Pass-Through Facility

Informix

ODBC

OLE DB

connections

establishing

terminating

CONNECTION_GROUP= option, SAS/ACCESS LIBNAME statement

CONN_OPTIONS= connection option (CA-OpenIngres)

constraints

CONTENTS procedure

CREATE statement, ACCESS procedure

CREATE TABLE statement, SQL procedure

CURSOR_TYPE= data set option

DB2 under UNIX and PC hosts

ODBC

OLE DB

CURSOR_TYPE= option, SAS/ACCESS LIBNAME statement

DB2 under UNIX and PC hosts

ODBC

OLE DB

CV2ODBC procedure

examples

syntax