Shopping Cart

No products in the cart.

BSI 22/30453896 DC 2022

$45.21

BS EN ISO/IEC 9075-3. Information technology. Database language SQL – Part 3. Call-Level Interface (SQL/CLI)

Published By Publication Date Number of Pages
BSI 2022 390
Guaranteed Safe Checkout
Category:

If you have any questions, feel free to reach out to our online customer service team by clicking on the bottom right corner. We’re here to assist you 24/7.
Email:[email protected]

PDF Catalog

PDF Pages PDF Title
1 30453896-NC.pdf
3 ISO_IEC DIS 9075-3 ed.6 – id.84803 Enquiry PDF (en) (1).pdf
5 Contents
9 Tables
11 Foreword
13 Introduction
15 1 Scope
16 2 Normative references
17 3 Terms and definitions
18 4 Concepts
4.1 Notations and conventions
4.1.1 Notations
4.1.2 Specification of routine definitions
4.2 Introduction to SQL/CLI
22 4.3 Return codes
23 4.4 Diagnostics areas in SQL/CLI
4.4.1 Introduction to diagnostics areas in SQL/CLI
26 4.4.2 Setting of ROW_NUMBER and COLUMN_NUMBER fields
4.5 Miscellaneous characteristics
4.5.1 Handles
4.5.2 Null terminated strings
27 4.5.3 Null pointers
4.5.4 Environment attributes
4.5.5 Connection attributes
28 4.5.6 Statement attributes
4.5.7 CLI descriptor areas
29 4.5.8 Obtaining diagnostics during multi-row fetch
30 4.6 SQL-invoked routines
4.6.1 Result sets returned by SQL-invoked procedures
4.7 Cursors
4.7.1 General description of cursors
4.8 Client-server operation
31 5 Lexical elements
5.1 and
32 6 Call-Level Interface specifications
6.1
40 6.2 invocation
43 6.3 Implicit set connection
44 6.4 Preparing a statement
46 6.5 Executing a statement
48 6.6 Implicit CLI prepared cursor
50 6.7 Implicit CLI procedural result cursor
51 6.8 Initial CLI cursor
52 6.9 Implicit DESCRIBE USING clause
58 6.10 Implicit EXECUTE USING and OPEN USING clauses
64 6.11 Implicit CALL USING clause
68 6.12 Fetching a rowset
72 6.13 Implicit FETCH USING clause
78 6.14 Character string retrieval
80 6.15 Binary string retrieval
81 6.16 Deferred parameter check
82 6.17 Description of CLI item descriptor areas
93 6.18 Other tables associated with CLI
117 6.19 SQL/CLI data type correspondences
127 7 SQL/CLI routines
7.1 Introduction to SQL/CLI routines
7.2 AllocConnect
128 7.3 AllocEnv
129 7.4 AllocHandle
133 7.5 AllocStmt
134 7.6 BindCol
136 7.7 BindParameter
140 7.8 Cancel
142 7.9 CloseCursor
143 7.10 ColAttribute
145 7.11 ColumnPrivileges
151 7.12 Columns
160 7.13 Connect
164 7.14 CopyDesc
165 7.15 DataSources
167 7.16 DescribeCol
169 7.17 Disconnect
171 7.18 EndTran
175 7.19 Error
177 7.20 ExecDirect
178 7.21 Execute
179 7.22 Fetch
180 7.23 FetchScroll
181 7.24 ForeignKeys
193 7.25 FreeConnect
194 7.26 FreeEnv
195 7.27 FreeHandle
198 7.28 FreeStmt
200 7.29 GetConnectAttr
202 7.30 GetCursorName
203 7.31 GetData
209 7.32 GetDescField
211 7.33 GetDescRec
213 7.34 GetDiagField
222 7.35 GetDiagRec
224 7.36 GetEnvAttr
226 7.37 GetFeatureInfo
229 7.38 GetFunctions
230 7.39 GetInfo
234 7.40 GetLength
236 7.41 GetParamData
241 7.42 GetPosition
243 7.43 GetSessionInfo
245 7.44 GetStmtAttr
248 7.45 GetSubString
250 7.46 GetTypeInfo
254 7.47 MoreResults
255 7.48 NextResult
256 7.49 NumResultCols
257 7.50 ParamData
262 7.51 Prepare
263 7.52 PrimaryKeys
268 7.53 PutData
271 7.54 RowCount
272 7.55 SetConnectAttr
274 7.56 SetCursorName
276 7.57 SetDescField
281 7.58 SetDescRec
283 7.59 SetEnvAttr
285 7.60 SetStmtAttr
289 7.61 SpecialColumns
296 7.62 StartTran
298 7.63 TablePrivileges
303 7.64 Tables
310 8 Additional data manipulation rules
8.1 Effect of opening a cursor
311 9 Dynamic SQL
9.1
312 10 Definition Schema
10.1 Definition Schema digital artifact
10.2 SQL_IMPLEMENTATION_INFO base table
315 10.3 SQL_SIZING base table
317 11 Status codes
11.1 SQLSTATE
320 12 Conformance
12.1 Claims of conformance to SQL/CLI
12.2 Additional conformance requirements for SQL/CLI
12.3 Implied feature relationships of SQL/CLI
321 A SQL Conformance Summary
323 B implementation-defined elements
347 C Implementation-dependent elements
353 D SQL optional feature taxonomy
354 E Deprecated features
355 F Incompatibilities with ISO/IEC 9075:2016
356 G Defect reports not addressed in this edition of this document
357 H Typical header files
H.1 C header file SQLCLI.H
368 H.2 COBOL library item SQLCLI
376 I Sample C programs
I.1 Introduction to Sample C programs
I.2 Create table, insert, select
379 I.3 Interactive Query
382 I.4 Providing long dynamic arguments at Execute time
385 Index
BSI 22/30453896 DC 2022
$45.21