DB Access Module for Microsoft SQL Server User's Guide
Rogue Wave web site: Home Page | Main Documentation Page
Rogue Wave web site: Home Page | Main Documentation Page
Topic Index
Click on one of the letters below to jump immediately to that section of the index.
A | B | C | D | E | F | G | H | I | L | M | N | O | P | R | S | T | U | V
A
access mode [in 2.17.3 Access Mode]accessMode() [in 2.17.3 Access Mode]
application name [in 2.17.10 Application Name]
applicationName() [in 2.17.10 Application Name]
B
beginTransaction() [in 2.11.2 Using Transaction Control Methods]bulk reads and writes [in 2.7.1 Support]
C
caching [in 2.6.1 Inserter Caching]caching, reader [in 2.6.2 Reader Caching]
caching
inserter [in 2.6.1 Inserter Caching]
performance [in 2.6.2 Reader Caching]
commitTransaction() [in 2.11.2 Using Transaction Control Methods]
connections
databases [in 2.2 Databases and Connections]
current qualifier [in 2.17.6 Current Qualifier]
currentQualifier() [in 2.17.6 Current Qualifier]
cursors [in 2.5 Cursors]
cursorType() [in 2.16.1 Cursor Type]
D
data binding [in 2.15 Input Binding of Data]database() [in 2.2 Databases and Connections]
databases
connections [in 2.2 Databases and Connections]
datatype mapping [in 2.3 Data Types]
datatypes
restrictions on use, table [in 2.3.1 Restrictions on the Use of Data Types]
DB2 CLI Access Module
using with static libraries [in 2.19 Using Static Libraries with MS SQL Server and DB2 CLI Access Modules]
E
error handling [in 2.12 Error Messages]and ODBC conformance [in 2.12.1 Errors and ODBC Conformance]
and RWDBStatus [in 2.12.2 Errors and RWDBStatus]
examples
opening a database [in 2.2 Databases and Connections]
opening the default database [in 2.2 Databases and Connections]
savepoint feature [in 2.11.2 Using Transaction Control Methods]
F
foreign keys from views, not implemented [in 2.17.14 Foreign Keys from Views]G
global functions [in 2.4.1 Global Functions]H
host name [in 2.17.11 Host Name]hostName() [in 2.17.11 Host Name]
I
identity columns [in 2.3.2 Using Identity Columns]input binding of data [in 2.15 Input Binding of Data]
inserter caching [in 2.6.1 Inserter Caching]
installation [in Chapter 1 Introduction]
[in 2.1 Introduction]
internationalization [in 2.10 Internationalization]
date bindings for [in 2.10.2 Data Bindings]
restrictions [in 2.10.3 Limitations]
setting environment variables for [in 2.10.1.1 Environment Variables]
isolation() [in 2.11.1 Setting Isolation Levels]
L
logging text updates [in 2.16.2 Logging of Text Updates]login timeout [in 2.17.1 Login Timeout]
loginTimeout() [in 2.17.1 Login Timeout]
logTextUpdates() [in 2.16.2 Logging of Text Updates]
M
mapping between datatypes [in 2.3 Data Types]max blob size [in 2.17.7 Max Blob Size]
max string size [in 2.17.8 Max String Size]
maxBlobSize() [in 2.17.7 Max Blob Size]
N
national language [in 2.17.9 National Language]nationalLanguage() [in 2.17.9 National Language]
nested transactions [in 2.11.2 Using Transaction Control Methods]
O
ODBC driverruntime loading [in 2.19 Using Static Libraries with MS SQL Server and DB2 CLI Access Modules]
ODBC functions
multiply-defined [in 2.19 Using Static Libraries with MS SQL Server and DB2 CLI Access Modules]
Open SQL [in 2.18 Open SQL and Microsoft SQL Server ODBC]
and stored procedures [in 2.18.3 Stored Procedures and Open SQL]
placeholder syntax [in 2.18.1 Placeholder Syntax]
[in 2.18.1 Placeholder Syntax]
supported datatypes for input binding [in 2.18.2 Supported Data Types for Input Binding]
opening a database connection
accessLib [in 2.2 Databases and Connections]
password [in 2.2 Databases and Connections]
required parameters [in 2.2 Databases and Connections]
server name [in 2.2 Databases and Connections]
user name [in 2.2 Databases and Connections]
outer joins [in 2.4.2 Outer Joins]
ANSI-compliant syntax example [in 2.4.2 Outer Joins]
P
packet size [in 2.17.12 Packet Size]packetSize() [in 2.17.12 Packet Size]
performance [in 2.6.2 Reader Caching]
[in 2.9.3 Instantiating an RWDBStoredProcedure Using Schema Data]
placeholder syntax [in 2.18.1 Placeholder Syntax]
[in 2.18.1 Placeholder Syntax]
portability [in 2.16 Contents of RWDBSystemHandle]
processing, correct sequence of [in 2.9.2 Executing Stored Procedures]
R
reader caching [in 2.6.2 Reader Caching]restrictions
foreign keys from views [in 2.17.14 Foreign Keys from Views]
[in 2.17.14 Foreign Keys from Views]
on internationalization [in 2.10.3 Limitations]
on providing values for identity columns [in 2.3.2 Using Identity Columns]
on use of datatypes, table [in 2.3.1 Restrictions on the Use of Data Types]
result sets [in 2.13 Result Sets]
rollbackTransaction() [in 2.11.2 Using Transaction Control Methods]
rows
insertion [in 2.3.2 Using Identity Columns]
runtime loading
of ODBC client [in 2.16 Contents of RWDBSystemHandle]
RWDBColumn, and datatype mapping [in 2.3 Data Types]
RWDBEnvironmentHandle [in 2.17 Contents of RWDBEnvironmentHandle]
RWDBMsSqlLibEnvironmentHandle [in 2.17 Contents of RWDBEnvironmentHandle]
[in 2.17.15 Using RWDBMsSqlLibEnvironmentHandle]
access mode [in 2.17.3 Access Mode]
application name [in 2.17.10 Application Name]
current qualifier [in 2.17.6 Current Qualifier]
foreign keys from views [in 2.17.14 Foreign Keys from Views]
host name [in 2.17.11 Host Name]
login timeout [in 2.17.1 Login Timeout]
max blob size [in 2.17.7 Max Blob Size]
max string size [in 2.17.8 Max String Size]
national language [in 2.17.9 National Language]
packet size [in 2.17.12 Packet Size]
secure login [in 2.17.13 Secure Login]
timeout [in 2.17.2 Query Timeout]
trace file name [in 2.17.5 .Trace File Name]
trace option [in 2.17.4 Trace Option]
RWDBMsSqlLibSystemHandle [in 2.16 Contents of RWDBSystemHandle]
RWDBStatus [in 2.12.2 Errors and RWDBStatus]
RWDBSystemHandle
contents [in 2.16 Contents of RWDBSystemHandle]
logging text updates [in 2.16.2 Logging of Text Updates]
specifying cursor type [in 2.16.1 Cursor Type]
text size [in 2.16.3 Text Size]
RWDBValue, and datatype mapping [in 2.3 Data Types]
RWDBValue
ValueType [in 2.3 Data Types]
S
savepoint feature [in 2.11.2 Using Transaction Control Methods]secure login [in 2.17.13 Secure Login]
secureLogin() [in 2.17.13 Secure Login]
sequence of processing [in 2.9.2 Executing Stored Procedures]
setSavepoint() [in 2.11.2 Using Transaction Control Methods]
SQLBindCol() [in 2.7.1 Support]
SQLBindParameter() [in 2.7.1 Support]
SQLHDBC hdbc() [in 2.16 Contents of RWDBSystemHandle]
SQL_ATTR_ROW_ARRAY_SIZE [in 2.6.2 Reader Caching]
SQL_CURSOR_FORWARD_ONLY [in 2.16.1 Cursor Type]
SQL_CURSOR_KEYSET_DRIVEN [in 2.16.1 Cursor Type]
SQL_CURSOR_STATIC [in 2.16.1 Cursor Type]
SQL_CURSOS_DYNAMIC [in 2.16.1 Cursor Type]
static libraries
using with more than one module [in 2.19 Using Static Libraries with MS SQL Server and DB2 CLI Access Modules]
stored procedures [in 2.9 Stored Procedures]
creating [in 2.9.1 Creating Stored Procedures]
executing [in 2.9.2 Executing Stored Procedures]
using schema data [in 2.9.3 Instantiating an RWDBStoredProcedure Using Schema Data]
storedProc() [in 2.9.3 Instantiating an RWDBStoredProcedure Using Schema Data]
[in 2.9.3 Instantiating an RWDBStoredProcedure Using Schema Data]
supported datatypes for input binding, Open SQL [in 2.18.2 Supported Data Types for Input Binding]
system tables in msSQL [in Appendix A System Tables and Stored Procedures]
systemHandle() [in 2.16 Contents of RWDBSystemHandle]
T
tablesrestrictions on datatypes [in 2.3.1 Restrictions on the Use of Data Types]
restrictions on global functions [in 2.4.1 Global Functions]
text size [in 2.16.3 Text Size]
textSize() [in 2.16.3 Text Size]
timeout [in 2.17.2 Query Timeout]
timeout() [in 2.17.2 Query Timeout]
trace file name [in 2.17.5 .Trace File Name]
trace option [in 2.17.4 Trace Option]
traceFileName() [in 2.17.5 .Trace File Name]
traceOption() [in 2.17.4 Trace Option]
transaction processing
methods [in 2.11.2 Using Transaction Control Methods]
transactions [in 2.11 Transaction Processing]
setting isolation levels [in 2.11.1 Setting Isolation Levels]
U
Unicode support [in 2.10 Internationalization]updating text and image data [in 2.14 Using Text and Image Data]
V
versions supported [in Chapter 1 Introduction]
© Copyright Rogue Wave Software, Inc. All Rights Reserved.
Rogue Wave and SourcePro are registered trademarks of Rogue Wave Software, Inc. in the United States and other countries. All other trademarks are the property of their respective owners.
Contact Rogue Wave about documentation or support issues.