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 |
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 |