🔥🔥 Don’t Miss Out on Our End of Autumn Sale. If you have any questions, feel free to click the bottom right corner to contact our customer service..

Concat us[email protected]
Shopping Cart

No products in the cart.

🔍
BS ISO/IEC 9075-3:2023

BS ISO/IEC 9075-3:2023

$215.11

Information technology. Database languages SQL – Call-Level Interface (SQL/CLI)

Published By Publication Date Number of Pages
BSI 2023 386
PDF Format Searchable Printable Preview Now
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
2 undefined
5 Contents
9 Tables
11 Foreword
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
47 6.5 Executing a statement
49 6.6 Implicit CLI prepared cursor
51 6.7 Implicit CLI procedural result cursor
52 6.8 Initial CLI cursor
53 6.9 Implicit DESCRIBE USING clause
59 6.10 Implicit EXECUTE USING and OPEN USING clauses
65 6.11 Implicit CALL USING clause
70 6.12 Fetching a rowset
74 6.13 Implicit FETCH USING clause
80 6.14 Character string retrieval
82 6.15 Binary string retrieval
84 6.16 Deferred parameter check
85 6.17 Description of CLI item descriptor areas
96 6.18 Other tables associated with CLI
120 6.19 SQL/CLI data type correspondences
130 7 SQL/CLI routines
7.1 Introduction to SQL/CLI routines
7.2 AllocConnect()
131 7.3 AllocEnv()
132 7.4 AllocHandle()
136 7.5 AllocStmt()
137 7.6 BindCol()
139 7.7 BindParameter()
143 7.8 Cancel()
145 7.9 CloseCursor()
146 7.10 ColAttribute()
148 7.11 ColumnPrivileges()
154 7.12 Columns()
163 7.13 Connect()
167 7.14 CopyDesc()
168 7.15 DataSources()
170 7.16 DescribeCol()
172 7.17 Disconnect()
174 7.18 EndTran()
178 7.19 Error()
180 7.20 ExecDirect()
181 7.21 Execute()
182 7.22 Fetch()
183 7.23 FetchScroll()
184 7.24 ForeignKeys()
196 7.25 FreeConnect()
197 7.26 FreeEnv()
198 7.27 FreeHandle()
201 7.28 FreeStmt()
203 7.29 GetConnectAttr()
205 7.30 GetCursorName()
206 7.31 GetData()
212 7.32 GetDescField()
214 7.33 GetDescRec()
216 7.34 GetDiagField()
225 7.35 GetDiagRec()
227 7.36 GetEnvAttr()
229 7.37 GetFeatureInfo()
232 7.38 GetFunctions()
233 7.39 GetInfo()
237 7.40 GetLength()
239 7.41 GetParamData()
245 7.42 GetPosition()
247 7.43 GetSessionInfo()
249 7.44 GetStmtAttr()
252 7.45 GetSubString()
254 7.46 GetTypeInfo()
258 7.47 MoreResults()
259 7.48 NextResult()
260 7.49 NumResultCols()
261 7.50 ParamData()
266 7.51 Prepare()
267 7.52 PrimaryKeys()
272 7.53 PutData()
275 7.54 RowCount()
276 7.55 SetConnectAttr()
278 7.56 SetCursorName()
280 7.57 SetDescField()
285 7.58 SetDescRec()
287 7.59 SetEnvAttr()
289 7.60 SetStmtAttr()
293 7.61 SpecialColumns()
300 7.62 StartTran()
302 7.63 TablePrivileges()
307 7.64 Tables()
314 8 Additional data manipulation rules
8.1 Effect of opening a cursor
315 9 Dynamic SQL
9.1
316 10 Status codes
10.1 SQLSTATE
319 11 Conformance
11.1 Claims of conformance to SQL/CLI
11.2 Additional conformance requirements for SQL/CLI
11.3 Implied feature relationships of SQL/CLI
320 A SQL conformance summary
322 B Implementation-defined elements
343 C Implementation-dependent elements
348 D SQL optional feature taxonomy
349 E Deprecated features
350 F Incompatibilities with ISO/IEC 9075:2016
351 G Defect Reports not addressed in this edition of this document
352 H Example header files
H.1 C header file sqlcli.h
363 H.2 COBOL library item SQLCLI
371 I Example C programs
I.1 Introduction to Example C programs
I.2 Create table, insert, select
374 I.3 Interactive Query
377 I.4 Providing long dynamic arguments at Execute time
380 Index

Related products

BS ISO/IEC 9075-3:2023
$215.11