{"id":410697,"date":"2024-10-20T05:41:36","date_gmt":"2024-10-20T05:41:36","guid":{"rendered":"https:\/\/pdfstandards.shop\/product\/uncategorized\/bsi-22-30453896-dc-2022\/"},"modified":"2024-10-26T10:29:13","modified_gmt":"2024-10-26T10:29:13","slug":"bsi-22-30453896-dc-2022","status":"publish","type":"product","link":"https:\/\/pdfstandards.shop\/product\/publishers\/bsi\/bsi-22-30453896-dc-2022\/","title":{"rendered":"BSI 22\/30453896 DC 2022"},"content":{"rendered":"
PDF Pages<\/th>\n | PDF Title<\/th>\n<\/tr>\n | ||||||
---|---|---|---|---|---|---|---|
1<\/td>\n | 30453896-NC.pdf <\/td>\n<\/tr>\n | ||||||
3<\/td>\n | ISO_IEC DIS 9075-3 ed.6 – id.84803 Enquiry PDF (en) (1).pdf <\/td>\n<\/tr>\n | ||||||
5<\/td>\n | Contents <\/td>\n<\/tr>\n | ||||||
9<\/td>\n | Tables <\/td>\n<\/tr>\n | ||||||
11<\/td>\n | 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 | ||||||
46<\/td>\n | 6.5 Executing a statement <\/td>\n<\/tr>\n | ||||||
48<\/td>\n | 6.6 Implicit CLI prepared cursor <\/td>\n<\/tr>\n | ||||||
50<\/td>\n | 6.7 Implicit CLI procedural result cursor <\/td>\n<\/tr>\n | ||||||
51<\/td>\n | 6.8 Initial CLI cursor <\/td>\n<\/tr>\n | ||||||
52<\/td>\n | 6.9 Implicit DESCRIBE USING clause <\/td>\n<\/tr>\n | ||||||
58<\/td>\n | 6.10 Implicit EXECUTE USING and OPEN USING clauses <\/td>\n<\/tr>\n | ||||||
64<\/td>\n | 6.11 Implicit CALL USING clause <\/td>\n<\/tr>\n | ||||||
68<\/td>\n | 6.12 Fetching a rowset <\/td>\n<\/tr>\n | ||||||
72<\/td>\n | 6.13 Implicit FETCH USING clause <\/td>\n<\/tr>\n | ||||||
78<\/td>\n | 6.14 Character string retrieval <\/td>\n<\/tr>\n | ||||||
80<\/td>\n | 6.15 Binary string retrieval <\/td>\n<\/tr>\n | ||||||
81<\/td>\n | 6.16 Deferred parameter check <\/td>\n<\/tr>\n | ||||||
82<\/td>\n | 6.17 Description of CLI item descriptor areas <\/td>\n<\/tr>\n | ||||||
93<\/td>\n | 6.18 Other tables associated with CLI <\/td>\n<\/tr>\n | ||||||
117<\/td>\n | 6.19 SQL\/CLI data type correspondences <\/td>\n<\/tr>\n | ||||||
127<\/td>\n | 7 SQL\/CLI routines 7.1 Introduction to SQL\/CLI routines 7.2 AllocConnect <\/td>\n<\/tr>\n | ||||||
128<\/td>\n | 7.3 AllocEnv <\/td>\n<\/tr>\n | ||||||
129<\/td>\n | 7.4 AllocHandle <\/td>\n<\/tr>\n | ||||||
133<\/td>\n | 7.5 AllocStmt <\/td>\n<\/tr>\n | ||||||
134<\/td>\n | 7.6 BindCol <\/td>\n<\/tr>\n | ||||||
136<\/td>\n | 7.7 BindParameter <\/td>\n<\/tr>\n | ||||||
140<\/td>\n | 7.8 Cancel <\/td>\n<\/tr>\n | ||||||
142<\/td>\n | 7.9 CloseCursor <\/td>\n<\/tr>\n | ||||||
143<\/td>\n | 7.10 ColAttribute <\/td>\n<\/tr>\n | ||||||
145<\/td>\n | 7.11 ColumnPrivileges <\/td>\n<\/tr>\n | ||||||
151<\/td>\n | 7.12 Columns <\/td>\n<\/tr>\n | ||||||
160<\/td>\n | 7.13 Connect <\/td>\n<\/tr>\n | ||||||
164<\/td>\n | 7.14 CopyDesc <\/td>\n<\/tr>\n | ||||||
165<\/td>\n | 7.15 DataSources <\/td>\n<\/tr>\n | ||||||
167<\/td>\n | 7.16 DescribeCol <\/td>\n<\/tr>\n | ||||||
169<\/td>\n | 7.17 Disconnect <\/td>\n<\/tr>\n | ||||||
171<\/td>\n | 7.18 EndTran <\/td>\n<\/tr>\n | ||||||
175<\/td>\n | 7.19 Error <\/td>\n<\/tr>\n | ||||||
177<\/td>\n | 7.20 ExecDirect <\/td>\n<\/tr>\n | ||||||
178<\/td>\n | 7.21 Execute <\/td>\n<\/tr>\n | ||||||
179<\/td>\n | 7.22 Fetch <\/td>\n<\/tr>\n | ||||||
180<\/td>\n | 7.23 FetchScroll <\/td>\n<\/tr>\n | ||||||
181<\/td>\n | 7.24 ForeignKeys <\/td>\n<\/tr>\n | ||||||
193<\/td>\n | 7.25 FreeConnect <\/td>\n<\/tr>\n | ||||||
194<\/td>\n | 7.26 FreeEnv <\/td>\n<\/tr>\n | ||||||
195<\/td>\n | 7.27 FreeHandle <\/td>\n<\/tr>\n | ||||||
198<\/td>\n | 7.28 FreeStmt <\/td>\n<\/tr>\n | ||||||
200<\/td>\n | 7.29 GetConnectAttr <\/td>\n<\/tr>\n | ||||||
202<\/td>\n | 7.30 GetCursorName <\/td>\n<\/tr>\n | ||||||
203<\/td>\n | 7.31 GetData <\/td>\n<\/tr>\n | ||||||
209<\/td>\n | 7.32 GetDescField <\/td>\n<\/tr>\n | ||||||
211<\/td>\n | 7.33 GetDescRec <\/td>\n<\/tr>\n | ||||||
213<\/td>\n | 7.34 GetDiagField <\/td>\n<\/tr>\n | ||||||
222<\/td>\n | 7.35 GetDiagRec <\/td>\n<\/tr>\n | ||||||
224<\/td>\n | 7.36 GetEnvAttr <\/td>\n<\/tr>\n | ||||||
226<\/td>\n | 7.37 GetFeatureInfo <\/td>\n<\/tr>\n | ||||||
229<\/td>\n | 7.38 GetFunctions <\/td>\n<\/tr>\n | ||||||
230<\/td>\n | 7.39 GetInfo <\/td>\n<\/tr>\n | ||||||
234<\/td>\n | 7.40 GetLength <\/td>\n<\/tr>\n | ||||||
236<\/td>\n | 7.41 GetParamData <\/td>\n<\/tr>\n | ||||||
241<\/td>\n | 7.42 GetPosition <\/td>\n<\/tr>\n | ||||||
243<\/td>\n | 7.43 GetSessionInfo <\/td>\n<\/tr>\n | ||||||
245<\/td>\n | 7.44 GetStmtAttr <\/td>\n<\/tr>\n | ||||||
248<\/td>\n | 7.45 GetSubString <\/td>\n<\/tr>\n | ||||||
250<\/td>\n | 7.46 GetTypeInfo <\/td>\n<\/tr>\n | ||||||
254<\/td>\n | 7.47 MoreResults <\/td>\n<\/tr>\n | ||||||
255<\/td>\n | 7.48 NextResult <\/td>\n<\/tr>\n | ||||||
256<\/td>\n | 7.49 NumResultCols <\/td>\n<\/tr>\n | ||||||
257<\/td>\n | 7.50 ParamData <\/td>\n<\/tr>\n | ||||||
262<\/td>\n | 7.51 Prepare <\/td>\n<\/tr>\n | ||||||
263<\/td>\n | 7.52 PrimaryKeys <\/td>\n<\/tr>\n | ||||||
268<\/td>\n | 7.53 PutData <\/td>\n<\/tr>\n | ||||||
271<\/td>\n | 7.54 RowCount <\/td>\n<\/tr>\n | ||||||
272<\/td>\n | 7.55 SetConnectAttr <\/td>\n<\/tr>\n | ||||||
274<\/td>\n | 7.56 SetCursorName <\/td>\n<\/tr>\n | ||||||
276<\/td>\n | 7.57 SetDescField <\/td>\n<\/tr>\n | ||||||
281<\/td>\n | 7.58 SetDescRec <\/td>\n<\/tr>\n | ||||||
283<\/td>\n | 7.59 SetEnvAttr <\/td>\n<\/tr>\n | ||||||
285<\/td>\n | 7.60 SetStmtAttr <\/td>\n<\/tr>\n | ||||||
289<\/td>\n | 7.61 SpecialColumns <\/td>\n<\/tr>\n | ||||||
296<\/td>\n | 7.62 StartTran <\/td>\n<\/tr>\n | ||||||
298<\/td>\n | 7.63 TablePrivileges <\/td>\n<\/tr>\n | ||||||
303<\/td>\n | 7.64 Tables <\/td>\n<\/tr>\n | ||||||
310<\/td>\n | 8 Additional data manipulation rules 8.1 Effect of opening a cursor <\/td>\n<\/tr>\n | ||||||
311<\/td>\n | 9 Dynamic SQL 9.1 <\/td>\n<\/tr>\n | ||||||
312<\/td>\n | 10 Definition Schema 10.1 Definition Schema digital artifact 10.2 SQL_IMPLEMENTATION_INFO base table <\/td>\n<\/tr>\n | ||||||
315<\/td>\n | 10.3 SQL_SIZING base table <\/td>\n<\/tr>\n | ||||||
317<\/td>\n | 11 Status codes 11.1 SQLSTATE <\/td>\n<\/tr>\n | ||||||
320<\/td>\n | 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 <\/td>\n<\/tr>\n | ||||||
321<\/td>\n | A SQL Conformance Summary <\/td>\n<\/tr>\n | ||||||
323<\/td>\n | B implementation-defined elements <\/td>\n<\/tr>\n | ||||||
347<\/td>\n | C Implementation-dependent elements <\/td>\n<\/tr>\n | ||||||
353<\/td>\n | D SQL optional feature taxonomy <\/td>\n<\/tr>\n | ||||||
354<\/td>\n | E Deprecated features <\/td>\n<\/tr>\n | ||||||
355<\/td>\n | F Incompatibilities with ISO\/IEC 9075:2016 <\/td>\n<\/tr>\n | ||||||
356<\/td>\n | G Defect reports not addressed in this edition of this document <\/td>\n<\/tr>\n | ||||||
357<\/td>\n | H Typical header files H.1 C header file SQLCLI.H <\/td>\n<\/tr>\n | ||||||
368<\/td>\n | H.2 COBOL library item SQLCLI <\/td>\n<\/tr>\n | ||||||
376<\/td>\n | I Sample C programs I.1 Introduction to Sample C programs I.2 Create table, insert, select <\/td>\n<\/tr>\n | ||||||
379<\/td>\n | I.3 Interactive Query <\/td>\n<\/tr>\n | ||||||
382<\/td>\n | I.4 Providing long dynamic arguments at Execute time <\/td>\n<\/tr>\n | ||||||
385<\/td>\n | Index <\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":" BS EN ISO\/IEC 9075-3. Information technology. Database language SQL – Part 3. Call-Level Interface (SQL\/CLI)<\/b><\/p>\n |