| 101 |
10.4 |
| 102 |
10.5 |
| 103 |
10.6 |
| 104 |
10.7 |
| 105 |
10.8 |
| 106 |
10.9 |
| 107 |
10.10 |
| 108 |
10.11 |
| 109 |
10.12 |
| 110 |
10.13 |
| 111 |
10.14 |
| 112 |
10.15 |
| 115 |
10.16 |
| 116 |
10.17 |
| 117 |
10.18 |
| 118 |
10.19 |
| 120 |
10.20 |
| 122 |
11 Access control
11.1 |
| 123 |
11.2 |
| 124 |
11.3 |
| 126 |
11.4 |
| 127 |
11.5 |
| 128 |
12 SQL-client modules
12.1 |
| 129 |
12.2 |
| 132 |
12.3 |
| 133 |
12.4 Data type correspondences |
| 136 |
13 Additional data manipulation rules
13.1 Effect of deleting rows from base tables |
| 137 |
13.2 Effect of inserting tables into base tables |
| 139 |
13.3 Effect of replacing rows in base tables |
| 141 |
14 Session management
14.1 |
| 143 |
15 Dynamic SQL
15.1 Description of SQL descriptor areas |
| 144 |
15.2 |
| 146 |
15.3 |
| 147 |
15.4 |
| 149 |
15.5 |
| 153 |
15.6 |
| 156 |
15.7 |
| 157 |
15.8 |
| 158 |
15.9 |
| 159 |
15.10 |
| 160 |
15.11 |
| 161 |
15.12 |
| 162 |
15.13 |
| 163 |
16 Embedded SQL
16.1 |
| 165 |
16.2 |
| 166 |
16.3 |
| 167 |
16.4 |
| 168 |
16.5 |
| 169 |
16.6 |
| 170 |
16.7 |
| 171 |
17 Diagnostics management
17.1 |
| 173 |
18 Call-Level Interface specifications
18.1 |
| 174 |
18.2 Implicit DESCRIBE USING clause |
| 175 |
18.3 Description of CLI item descriptor areas |
| 176 |
18.4 Other tables associated with CLI |
| 178 |
18.5 SQL/CLI data type correspondences |
| 180 |
19 SQL/CLI routines
19.1 BuildDataLink() |
| 181 |
19.2 GetDataLinkAttr() |
| 183 |
19.3 GetInfo() |
| 184 |
20 URLs
20.1 URL format |
| 187 |
21 Catalog manipulation
21.1 |
| 189 |
21.2 |
| 190 |
21.3 |
| 192 |
21.4 |
| 194 |
21.5 |
| 195 |
21.6 |
| 196 |
21.7 |
| 198 |
21.8 |
| 199 |
21.9 |
| 200 |
21.10 |
| 201 |
22 SQL/MED common specifications
22.1 Description of foreign-data wrapper item descriptor areas |
| 205 |
22.2 Implicit foreign-data wrapper cursor |
| 207 |
22.3 Implicit DESCRIBE INPUT USING clause for external data |
| 210 |
22.4 Implicit DESCRIBE OUTPUT USING clause for external data |
| 214 |
22.5 Implicit EXECUTE USING and OPEN USING clauses for external data |
| 217 |
22.6 Implicit FETCH USING clause for external data |
| 221 |
22.7 Character string retrieval for external data |
| 222 |
22.8 Binary string retrieval for external data |
| 223 |
22.9 Tables used with SQL/MED |
| 234 |
23 Foreign-data wrapper interface routines
23.1 |
| 239 |
23.2 invocation |
| 241 |
23.3 AdvanceInitRequest() |
| 242 |
23.4 AllocQueryContext() |
| 243 |
23.5 AllocWrapperEnv() |
| 245 |
23.6 Close() |
| 246 |
23.7 ConnectServer() |
| 248 |
23.8 FreeExecutionHandle() |
| 250 |
23.9 FreeFSConnection() |
| 251 |
23.10 FreeQueryContext() |
| 252 |
23.11 FreeReplyHandle() |
| 253 |
23.12 FreeWrapperEnv() |
| 254 |
23.13 GetNextReply() |
| 255 |
23.14 GetNumReplyBoolVE() |
| 256 |
23.15 GetNumReplyOrderBy() |
| 257 |
23.16 GetNumReplySelectElems() |
| 258 |
23.17 GetNumReplyTableRefs() |
| 259 |
23.18 GetOpts() |
| 261 |
23.19 GetReplyBoolVE() |
| 262 |
23.20 GetReplyCardinality() |
| 263 |
23.21 GetReplyDistinct() |
| 264 |
23.22 GetReplyExecCost() |
| 265 |
23.23 GetReplyFirstCost() |
| 266 |
23.24 GetReplyOrderElem() |
| 267 |
23.25 GetReplyReExecCost)( |
| 268 |
23.26 GetReplySelectElem() |
| 269 |
23.27 GetReplyTableRef() |
| 270 |
23.28 GetSPDHandle() |
| 271 |
23.29 GetSRDHandle() |
| 272 |
23.30 GetStatistics() |
| 274 |
23.31 GetWPDHandle() |
| 275 |
23.32 GetWRDHandle() |
| 276 |
23.33 InitRequest() |
| 280 |
23.34 Iterate() |
| 282 |
23.35 Open() |
| 283 |
23.36 ReOpen() |
| 284 |
23.37 Execution of Open() |
| 288 |
23.38 TransmitRequest() |
| 291 |
23.39 AllocDescriptor() |
| 292 |
23.40 FreeDescriptor() |
| 293 |
23.41 GetAuthorizationId() |
| 294 |
23.42 GetBoolVE() |
| 295 |
23.43 GetDescriptor() |
| 297 |
23.44 GetDistinct() |
| 298 |
23.45 GetNumBoolVE() |
| 299 |
23.46 GetNumChildren() |
| 300 |
23.47 GetNumOrderByElems() |
| 301 |
23.48 GetNumRoutMapOpts() |
| 302 |
23.49 GetNumSelectElems() |
| 303 |
23.50 GetNumServerOpts() |
| 304 |
23.51 GetNumTableColOpts() |
| 306 |
23.52 GetNumTableOpts() |
| 307 |
23.53 GetNumTableRefElems() |
| 308 |
23.54 GetNumUserOpts() |
| 309 |
23.55 GetNumWrapperOpts() |
| 310 |
23.56 GetOrderByElem() |
| 311 |
23.57 GetRoutMapOpt() |
| 313 |
23.58 GetRoutMapOptName() |
| 315 |
23.59 GetRoutineMapping() |
| 316 |
23.60 GetSelectElem() |
| 317 |
23.61 GetSelectElemType() |
| 318 |
23.62 GetServerName() |
| 319 |
23.63 GetServerOpt() |
| 321 |
23.64 GetServerOptByName() |
| 323 |
23.65 GetServerType() |
| 324 |
23.66 GetServerVersion() |
| 325 |
23.67 GetSQLString() |
| 326 |
23.68 GetTableColOpt() |
| 328 |
23.69 GetTableColOptByName() |
| 330 |
23.70 GetTableOpt() |
| 331 |
23.71 GetTableOptByName() |
| 333 |
23.72 GetTableRefElem() |
| 334 |
23.73 GetTableRefElemType() |
| 335 |
23.74 GetTableRefTableName() |
| 336 |
23.75 GetTableServerName() |
| 337 |
23.76 GetTRDHandle() |
| 338 |
23.77 GetUserOpt() |
| 340 |
23.78 GetUserOptByName() |
| 342 |
23.79 GetValExprColName() |
| 343 |
23.80 GetValueExpDesc() |
| 344 |
23.81 GetValueExpKind() |
| 345 |
23.82 GetValueExpName() |
| 346 |
23.83 GetValueExpTable() |
| 347 |
23.84 GetVEChild() |
| 348 |
23.85 GetWrapperLibraryName() |
| 349 |
23.86 GetWrapperName() |
| 350 |
23.87 GetWrapperOpt() |
| 352 |
23.88 GetWrapperOptByName() |
| 354 |
23.89 SetDescriptor() |
| 359 |
23.90 GetDiagnostics() |
| 363 |
24 Information Schema
24.1 Information Schema digital artifact
24.2 ATTRIBUTES view |
| 364 |
24.3 COLUMN_OPTIONS view |
| 365 |
24.4 COLUMNS view |
| 366 |
24.5 FOREIGN_DATA_WRAPPER_OPTIONS view |
| 367 |
24.6 FOREIGN_DATA_WRAPPERS view |
| 368 |
24.7 FOREIGN_SERVER_OPTIONS view |
| 369 |
24.8 FOREIGN_SERVERS view |
| 370 |
24.9 FOREIGN_TABLE_OPTIONS view |
| 371 |
24.10 FOREIGN_TABLES view |
| 372 |
24.11 ROUTINE_MAPPING_OPTIONS view |
| 373 |
24.12 ROUTINE_MAPPINGS view |
| 374 |
24.13 USER_MAPPING_OPTIONS view |
| 375 |
24.14 USER_MAPPINGS view |
| 376 |
24.15 Short name views |
| 380 |
25 Definition Schema
25.1 Definition Schema digital artifact
25.2 COLUMN_OPTIONS base table |
| 382 |
25.3 DATA_TYPE_DESCRIPTOR base table |
| 389 |
25.4 FOREIGN_DATA_WRAPPER_OPTIONS base table |
| 390 |
25.5 FOREIGN_DATA_WRAPPERS base table |
| 391 |
25.6 FOREIGN_SERVER_OPTIONS base table |
| 392 |
25.7 FOREIGN_SERVERS base table |
| 393 |
25.8 FOREIGN_TABLE_OPTIONS base table |
| 394 |
25.9 FOREIGN_TABLES base table |
| 395 |
25.10 ROUTINE_MAPPING_OPTIONS base table |
| 396 |
25.11 ROUTINE_MAPPINGS base table |
| 397 |
25.12 SQL_SIZING base table |
| 398 |
25.13 TABLES base table |
| 399 |
25.14 USAGE_PRIVILEGES base table |
| 400 |
25.15 USER_MAPPING_OPTIONS base table |
| 401 |
25.16 USER_MAPPINGS base table |
| 402 |
26 Status codes
26.1 SQLSTATE |
| 405 |
27 Conformance
27.1 Claims of conformance to SQL/MED
27.2 Additional conformance requirements for SQL/MED |
| 408 |
A SQL conformance summary |
| 426 |
B Implementation-defined elements |
| 440 |
C Implementation-dependent elements |
| 445 |
D SQL optional feature taxonomy |
| 447 |
E Deprecated features |
| 448 |
F Incompatibilities with ISO/IEC 9075:2016 |
| 449 |
G Defect Reports not addressed in this edition of this document |
| 450 |
H Example header files
H.1 C header file sqlcli.h |
| 451 |
H.2 COBOL library item SQLCLI |
| 453 |
I SQL/MED model |
| 457 |
Bibliography |
| 458 |
Index |
