BS ISO/IEC 9075-3:1999

Foreword
Introduction
1 Scope
2 Normative references
3 Definitions, notations and conventions
    3.1 Definitions
          3.1.1 Definitions provided in Part 3
    3.2 Notations
    3.3 Conventions
          3.3.1 Specification of routine definitions
          3.3.2 Relationships to other parts of
                  ISO/IEC 9075
                  3.3.2.1 Clause, Subclause, and
                            Table relationships
    3.4 Object Identifier for Database Language SQL
4 Concepts
    4.1 Introduction to SQL/CLI
    4.2 Return codes
    4.3 Diagnostics areas in SQL/CLI
          4.3.1 Setting of ROW_NUMBER and
                  COLUMN_NUMBER fields
    4.4 Miscellaneous characteristics
          4.4.1 Handles
          4.4.2 Null terminated strings
          4.4.3 Null pointers
          4.4.4 Environment attributes
          4.4.5 Connection attributes
          4.4.6 Statement attributes
          4.4.7 CLI descriptor areas
          4.4.8 Obtaining diagnostics during
                  multi-row fetch
    4.5 Client-server operation
5 Call-Level Interface specifications
    5.1
    5.2 invocation
    5.3 Implicit set connection
    5.4 Implicit cursor
    5.5 Implicit DESCRIBE USING clause
    5.6 Implicit EXECUTE USING and OPEN USING
          clauses
    5.7 Implicit CALL USING clause
    5.8 Implicit FETCH USING clause
    5.9 Character string retrieval
    5.10 Binary large object string retrieval
    5.11 Deferred parameter check
    5.12 CLI-specific status codes
    5.13 Description of CLI item descriptor areas
    5.14 Other tables associated with CLI
    5.15 Data type correspondences
6 SQL/CLI routines
    6.1 AllocConnect
    6.2 AllocEnv
    6.3 AllocHandle
    6.4 AllocStmt
    6.5 BindCol
    6.6 BindParameter
    6.7 Cancel
    6.8 CloseCursor
    6.9 ColAttribute
    6.10 ColumnPrivileges
    6.11 Columns
    6.12 Connect
    6.13 CopyDesc
    6.14 DataSources
    6.15 DescribeCol
    6.16 Disconnect
    6.17 EndTran
    6.18 Error
    6.19 ExecDirect
    6.20 Execute
    6.21 Fetch
    6.22 FetchScroll
    6.23 ForeignKeys
    6.24 FreeConnect
    6.25 FreeEnv
    6.26 FreeHandle
    6.27 FreeStmt
    6.28 GetConnectAttr
    6.29 GetCursorName
    6.30 GetData
    6.31 GetDescField
    6.32 GetDescRec
    6.33 GetDiagField
    6.34 GetDiagRec
    6.35 GetEnvAttr
    6.36 GetFeatureInfo
    6.37 GetFunctions
    6.38 GetInfo
    6.39 GetLength
    6.40 GetParamData
    6.41 GetPosition
    6.42 GetSessionInfo
    6.43 GetStmtAttr
    6.44 GetSubString
    6.45 GetTypeInfo
    6.46 MoreResults
    6.47 NextResult
    6.48 NumResultCols
    6.49 ParamData
    6.50 Prepare
    6.51 PrimaryKeys
    6.52 PutData
    6.53 RowCount
    6.54 SetConnectAttr
    6.55 SetCursorName
    6.56 SetDescField
    6.57 SetDescRec
    6.58 SetEnvAttr
    6.59 SetStmtAttr
    6.60 SpecialColumns
    6.61 StartTran
    6.62 TablePrivileges
    6.63 Tables
7 Definition Schema
    7.1 SQL_IMPLEMENTATION_INFO base table
    7.2 SQL_SIZING base table
    7.3 SQL_LANGUAGES base table
8 Conformance
    8.1 Conformance to SQL/CLI
    8.2 Claims of conformance
    8.3 Extensions and options
Annexes
A Typical header files
B Sample C programs
C Implementation-defined elements
D Implementation-dependent elements
E Incompatibilities with ISO/IEC 9075-3:1995
F Deprecated features
G SQL feature and package taxonomy
Index
Tables
1 Clause, Subclause, and Table relationships
2 Fields in SQL/CLI diagnostics areas
3 Supported calling conventions of SQL/CLI routines
    by language
4 Abbreviated SQL/CLI generic names
5 SQLSTATE class and subclass values for
    SQL/CLI-specific conditions
6 Fields in SQL/CLI row and parameter descriptor
    areas
7 Codes used for implementation data types in
    SQL/CLI
8 Codes used for application data types in SQL/CLI
9 Codes associated with datetime data types in
    SQL/CLI
10 Codes associated with in
    SQL/CLI
11 Codes associated with in SQL/CLI
12 Codes used for diagnostic fields
13 Codes used for handle types
14 Codes used for transaction termination
15 Codes used for environment attributes
16 Codes used for connection attributes
17 Codes used for statement attributes
18 Codes used for FreeStmt options
19 Data types of attributes
20 Codes used for descriptor fields
21 Ability to set SQL/CLI descriptor fields
22 Ability to retrieve SQL/CLI descriptor fields
23 SQL/CLI descriptor field default values
24 Codes used for fetch orientation
25 Multi-row fetch status codes
26 Miscellaneous codes used in CLI
27 Codes used to identify SQL/CLI routines
28 Codes and data types for implementation information
29 Codes and data types for session implementation
    information
30 Values for ALTER TABLE with GetInfo
31 Values for FETCH DIRECTION with GetInfo
32 Values for GETDATA EXTENSIONS with GetInfo
33 Values for OUTER JOIN CAPABILITIES with GetInfo
34 Values for SCROLL CONCURRENCY with GetInfo
35 Values for TRANSACTION ISOLATION OPTION with
    GetInfo and StartTran
36 Values for TRANSACTION ACCESS MODE with StartTran
37 Codes used for concise data types
38 Codes used with concise datetime data types
    in SQL/CLI
39 Codes used with concise interval data types
    in SQL/CLI
40 Concise codes used with datetime data types
    in SQL/CLI
41 Concise codes used with interval data types
    in SQL/CLI
42 Special parameter values
43 Column types and scopes used with SpecialColumns
44 Data type correspondences for Ada
45 Data type correspondences for C
46 Data type correspondences for COBOL
47 Data type correspondences for Fortran
48 Data type correspondences for MUMPS
49 Data type correspondences for Pascal
50 Data type correspondences for PL/I
51 SQL/CLI feature taxonomy

Specifies the structures and procedures for use in execution of statements of database language SQL from within an application written in a standard programming language, so that procedures are independent of the SQL statements being executed.