{"id":434878,"date":"2024-10-20T07:46:35","date_gmt":"2024-10-20T07:46:35","guid":{"rendered":"https:\/\/pdfstandards.shop\/product\/uncategorized\/bs-iso-iec-9075-32023\/"},"modified":"2024-10-26T14:44:53","modified_gmt":"2024-10-26T14:44:53","slug":"bs-iso-iec-9075-32023","status":"publish","type":"product","link":"https:\/\/pdfstandards.shop\/product\/publishers\/bsi\/bs-iso-iec-9075-32023\/","title":{"rendered":"BS ISO\/IEC 9075-3:2023"},"content":{"rendered":"
PDF Pages<\/th>\n | PDF Title<\/th>\n<\/tr>\n | ||||||
---|---|---|---|---|---|---|---|
2<\/td>\n | undefined <\/td>\n<\/tr>\n | ||||||
5<\/td>\n | Contents <\/td>\n<\/tr>\n | ||||||
9<\/td>\n | Tables <\/td>\n<\/tr>\n | ||||||
11<\/td>\n | Foreword Foreword <\/td>\n<\/tr>\n | ||||||
13<\/td>\n | Introduction <\/td>\n<\/tr>\n | ||||||
15<\/td>\n | 1 Scope <\/td>\n<\/tr>\n | ||||||
16<\/td>\n | 2 Normative references <\/td>\n<\/tr>\n | ||||||
17<\/td>\n | 3 Terms and definitions <\/td>\n<\/tr>\n | ||||||
18<\/td>\n | 4 Concepts 4.1 Notations and conventions 4.1.1 Notations 4.1.2 Specification of routine definitions 4.2 Introduction to SQL\/CLI <\/td>\n<\/tr>\n | ||||||
22<\/td>\n | 4.3 Return codes <\/td>\n<\/tr>\n | ||||||
23<\/td>\n | 4.4 Diagnostics areas in SQL\/CLI 4.4.1 Introduction to diagnostics areas in SQL\/CLI <\/td>\n<\/tr>\n | ||||||
26<\/td>\n | 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 <\/td>\n<\/tr>\n | ||||||
27<\/td>\n | 4.5.3 Null pointers 4.5.4 Environment attributes 4.5.5 Connection attributes <\/td>\n<\/tr>\n | ||||||
28<\/td>\n | 4.5.6 Statement attributes 4.5.7 CLI descriptor areas <\/td>\n<\/tr>\n | ||||||
29<\/td>\n | 4.5.8 Obtaining diagnostics during multi-row fetch <\/td>\n<\/tr>\n | ||||||
30<\/td>\n | 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 <\/td>\n<\/tr>\n | ||||||
31<\/td>\n | 5 Lexical elements 5.1 and <\/td>\n<\/tr>\n | ||||||
32<\/td>\n | 6 Call-Level Interface specifications 6.1 <\/td>\n<\/tr>\n | ||||||
40<\/td>\n | 6.2 invocation <\/td>\n<\/tr>\n | ||||||
43<\/td>\n | 6.3 Implicit set connection <\/td>\n<\/tr>\n | ||||||
44<\/td>\n | 6.4 Preparing a statement <\/td>\n<\/tr>\n | ||||||
47<\/td>\n | 6.5 Executing a statement <\/td>\n<\/tr>\n | ||||||
49<\/td>\n | 6.6 Implicit CLI prepared cursor <\/td>\n<\/tr>\n | ||||||
51<\/td>\n | 6.7 Implicit CLI procedural result cursor <\/td>\n<\/tr>\n | ||||||
52<\/td>\n | 6.8 Initial CLI cursor <\/td>\n<\/tr>\n | ||||||
53<\/td>\n | 6.9 Implicit DESCRIBE USING clause <\/td>\n<\/tr>\n | ||||||
59<\/td>\n | 6.10 Implicit EXECUTE USING and OPEN USING clauses <\/td>\n<\/tr>\n | ||||||
65<\/td>\n | 6.11 Implicit CALL USING clause <\/td>\n<\/tr>\n | ||||||
70<\/td>\n | 6.12 Fetching a rowset <\/td>\n<\/tr>\n | ||||||
74<\/td>\n | 6.13 Implicit FETCH USING clause <\/td>\n<\/tr>\n | ||||||
80<\/td>\n | 6.14 Character string retrieval <\/td>\n<\/tr>\n | ||||||
82<\/td>\n | 6.15 Binary string retrieval <\/td>\n<\/tr>\n | ||||||
84<\/td>\n | 6.16 Deferred parameter check <\/td>\n<\/tr>\n | ||||||
85<\/td>\n | 6.17 Description of CLI item descriptor areas <\/td>\n<\/tr>\n | ||||||
96<\/td>\n | 6.18 Other tables associated with CLI <\/td>\n<\/tr>\n | ||||||
120<\/td>\n | 6.19 SQL\/CLI data type correspondences <\/td>\n<\/tr>\n | ||||||
130<\/td>\n | 7 SQL\/CLI routines 7.1 Introduction to SQL\/CLI routines 7.2 AllocConnect() <\/td>\n<\/tr>\n | ||||||
131<\/td>\n | 7.3 AllocEnv() <\/td>\n<\/tr>\n | ||||||
132<\/td>\n | 7.4 AllocHandle() <\/td>\n<\/tr>\n | ||||||
136<\/td>\n | 7.5 AllocStmt() <\/td>\n<\/tr>\n | ||||||
137<\/td>\n | 7.6 BindCol() <\/td>\n<\/tr>\n | ||||||
139<\/td>\n | 7.7 BindParameter() <\/td>\n<\/tr>\n | ||||||
143<\/td>\n | 7.8 Cancel() <\/td>\n<\/tr>\n | ||||||
145<\/td>\n | 7.9 CloseCursor() <\/td>\n<\/tr>\n | ||||||
146<\/td>\n | 7.10 ColAttribute() <\/td>\n<\/tr>\n | ||||||
148<\/td>\n | 7.11 ColumnPrivileges() <\/td>\n<\/tr>\n | ||||||
154<\/td>\n | 7.12 Columns() <\/td>\n<\/tr>\n | ||||||
163<\/td>\n | 7.13 Connect() <\/td>\n<\/tr>\n | ||||||
167<\/td>\n | 7.14 CopyDesc() <\/td>\n<\/tr>\n | ||||||
168<\/td>\n | 7.15 DataSources() <\/td>\n<\/tr>\n | ||||||
170<\/td>\n | 7.16 DescribeCol() <\/td>\n<\/tr>\n | ||||||
172<\/td>\n | 7.17 Disconnect() <\/td>\n<\/tr>\n | ||||||
174<\/td>\n | 7.18 EndTran() <\/td>\n<\/tr>\n | ||||||
178<\/td>\n | 7.19 Error() <\/td>\n<\/tr>\n | ||||||
180<\/td>\n | 7.20 ExecDirect() <\/td>\n<\/tr>\n | ||||||
181<\/td>\n | 7.21 Execute() <\/td>\n<\/tr>\n | ||||||
182<\/td>\n | 7.22 Fetch() <\/td>\n<\/tr>\n | ||||||
183<\/td>\n | 7.23 FetchScroll() <\/td>\n<\/tr>\n | ||||||
184<\/td>\n | 7.24 ForeignKeys() <\/td>\n<\/tr>\n | ||||||
196<\/td>\n | 7.25 FreeConnect() <\/td>\n<\/tr>\n | ||||||
197<\/td>\n | 7.26 FreeEnv() <\/td>\n<\/tr>\n | ||||||
198<\/td>\n | 7.27 FreeHandle() <\/td>\n<\/tr>\n | ||||||
201<\/td>\n | 7.28 FreeStmt() <\/td>\n<\/tr>\n | ||||||
203<\/td>\n | 7.29 GetConnectAttr() <\/td>\n<\/tr>\n | ||||||
205<\/td>\n | 7.30 GetCursorName() <\/td>\n<\/tr>\n | ||||||
206<\/td>\n | 7.31 GetData() <\/td>\n<\/tr>\n | ||||||
212<\/td>\n | 7.32 GetDescField() <\/td>\n<\/tr>\n | ||||||
214<\/td>\n | 7.33 GetDescRec() <\/td>\n<\/tr>\n | ||||||
216<\/td>\n | 7.34 GetDiagField() <\/td>\n<\/tr>\n | ||||||
225<\/td>\n | 7.35 GetDiagRec() <\/td>\n<\/tr>\n | ||||||
227<\/td>\n | 7.36 GetEnvAttr() <\/td>\n<\/tr>\n | ||||||
229<\/td>\n | 7.37 GetFeatureInfo() <\/td>\n<\/tr>\n | ||||||
232<\/td>\n | 7.38 GetFunctions() <\/td>\n<\/tr>\n | ||||||
233<\/td>\n | 7.39 GetInfo() <\/td>\n<\/tr>\n | ||||||
237<\/td>\n | 7.40 GetLength() <\/td>\n<\/tr>\n | ||||||
239<\/td>\n | 7.41 GetParamData() <\/td>\n<\/tr>\n | ||||||
245<\/td>\n | 7.42 GetPosition() <\/td>\n<\/tr>\n | ||||||
247<\/td>\n | 7.43 GetSessionInfo() <\/td>\n<\/tr>\n | ||||||
249<\/td>\n | 7.44 GetStmtAttr() <\/td>\n<\/tr>\n | ||||||
252<\/td>\n | 7.45 GetSubString() <\/td>\n<\/tr>\n | ||||||
254<\/td>\n | 7.46 GetTypeInfo() <\/td>\n<\/tr>\n | ||||||
258<\/td>\n | 7.47 MoreResults() <\/td>\n<\/tr>\n | ||||||
259<\/td>\n | 7.48 NextResult() <\/td>\n<\/tr>\n | ||||||
260<\/td>\n | 7.49 NumResultCols() <\/td>\n<\/tr>\n | ||||||
261<\/td>\n | 7.50 ParamData() <\/td>\n<\/tr>\n | ||||||
266<\/td>\n | 7.51 Prepare() <\/td>\n<\/tr>\n | ||||||
267<\/td>\n | 7.52 PrimaryKeys() <\/td>\n<\/tr>\n | ||||||
272<\/td>\n | 7.53 PutData() <\/td>\n<\/tr>\n | ||||||
275<\/td>\n | 7.54 RowCount() <\/td>\n<\/tr>\n | ||||||
276<\/td>\n | 7.55 SetConnectAttr() <\/td>\n<\/tr>\n | ||||||
278<\/td>\n | 7.56 SetCursorName() <\/td>\n<\/tr>\n | ||||||
280<\/td>\n | 7.57 SetDescField() <\/td>\n<\/tr>\n | ||||||
285<\/td>\n | 7.58 SetDescRec() <\/td>\n<\/tr>\n | ||||||
287<\/td>\n | 7.59 SetEnvAttr() <\/td>\n<\/tr>\n | ||||||
289<\/td>\n | 7.60 SetStmtAttr() <\/td>\n<\/tr>\n | ||||||
293<\/td>\n | 7.61 SpecialColumns() <\/td>\n<\/tr>\n | ||||||
300<\/td>\n | 7.62 StartTran() <\/td>\n<\/tr>\n | ||||||
302<\/td>\n | 7.63 TablePrivileges() <\/td>\n<\/tr>\n | ||||||
307<\/td>\n | 7.64 Tables() <\/td>\n<\/tr>\n | ||||||
314<\/td>\n | 8 Additional data manipulation rules 8.1 Effect of opening a cursor <\/td>\n<\/tr>\n | ||||||
315<\/td>\n | 9 Dynamic SQL 9.1 <\/td>\n<\/tr>\n | ||||||
316<\/td>\n | 10 Status codes 10.1 SQLSTATE <\/td>\n<\/tr>\n | ||||||
319<\/td>\n | 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 <\/td>\n<\/tr>\n | ||||||
320<\/td>\n | A SQL conformance summary <\/td>\n<\/tr>\n | ||||||
322<\/td>\n | B Implementation-defined elements <\/td>\n<\/tr>\n | ||||||
343<\/td>\n | C Implementation-dependent elements <\/td>\n<\/tr>\n | ||||||
348<\/td>\n | D SQL optional feature taxonomy <\/td>\n<\/tr>\n | ||||||
349<\/td>\n | E Deprecated features <\/td>\n<\/tr>\n | ||||||
350<\/td>\n | F Incompatibilities with ISO\/IEC 9075:2016 <\/td>\n<\/tr>\n | ||||||
351<\/td>\n | G Defect Reports not addressed in this edition of this document <\/td>\n<\/tr>\n | ||||||
352<\/td>\n | H Example header files H.1 C header file sqlcli.h <\/td>\n<\/tr>\n | ||||||
363<\/td>\n | H.2 COBOL library item SQLCLI <\/td>\n<\/tr>\n | ||||||
371<\/td>\n | I Example C programs I.1 Introduction to Example C programs I.2 Create table, insert, select <\/td>\n<\/tr>\n | ||||||
374<\/td>\n | I.3 Interactive Query <\/td>\n<\/tr>\n | ||||||
377<\/td>\n | I.4 Providing long dynamic arguments at Execute time <\/td>\n<\/tr>\n | ||||||
380<\/td>\n | Index <\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":" Information technology. Database languages SQL – Call-Level Interface (SQL\/CLI)<\/b><\/p>\n |