| 100 |
10.4 |
| 101 |
10.5 |
| 102 |
10.6 |
| 103 |
10.7 |
| 104 |
10.8 |
| 105 |
10.9 |
| 106 |
10.10 |
| 107 |
10.11 |
| 108 |
10.12 |
| 109 |
10.13 |
| 110 |
10.14 |
| 111 |
10.15 |
| 114 |
10.16 |
| 115 |
10.17 |
| 116 |
10.18 |
| 117 |
10.19 |
| 119 |
10.20 |
| 121 |
11 Access control
11.1 |
| 122 |
11.2 |
| 123 |
11.3 |
| 125 |
11.4 |
| 126 |
11.5 |
| 127 |
12 SQL-client modules
12.1 |
| 128 |
12.2 |
| 131 |
12.3 |
| 132 |
12.4 Data type correspondences |
| 135 |
13 Additional data manipulation rules
13.1 Effect of deleting rows from base tables |
| 136 |
13.2 Effect of inserting tables into base tables |
| 138 |
13.3 Effect of replacing rows in base tables |
| 140 |
14 Session management
14.1 |
| 142 |
15 Dynamic SQL
15.1 Description of SQL descriptor areas |
| 143 |
15.2 |
| 145 |
15.3 |
| 146 |
15.4 |
| 148 |
15.5 |
| 152 |
15.6 |
| 155 |
15.7 |
| 156 |
15.8 |
| 157 |
15.9 |
| 158 |
15.10 |
| 159 |
15.11 |
| 160 |
15.12 |
| 161 |
15.13 |
| 162 |
16 Embedded SQL
16.1 |
| 164 |
16.2 |
| 165 |
16.3 |
| 166 |
16.4 |
| 167 |
16.5 |
| 168 |
16.6 |
| 169 |
16.7 |
| 170 |
17 Diagnostics management
17.1 |
| 172 |
18 Call-Level Interface specifications
18.1 |
| 173 |
18.2 Implicit DESCRIBE USING clause |
| 174 |
18.3 Description of CLI item descriptor areas |
| 175 |
18.4 Other tables associated with CLI |
| 177 |
18.5 SQL/CLI data type correspondences |
| 179 |
19 SQL/CLI routines
19.1 BuildDataLink |
| 180 |
19.2 GetDataLinkAttr |
| 182 |
19.3 GetInfo |
| 183 |
20 URLs
20.1 URL format |
| 186 |
21 Catalog manipulation
21.1 |
| 188 |
21.2 |
| 189 |
21.3 |
| 191 |
21.4 |
| 193 |
21.5 |
| 194 |
21.6 |
| 195 |
21.7 |
| 197 |
21.8 |
| 198 |
21.9 |
| 199 |
21.10 |
| 200 |
22 SQL/MED common specifications
22.1 Description of foreign-data wrapper item descriptor areas |
| 204 |
22.2 Implicit foreign-data wrapper cursor |
| 206 |
22.3 Implicit DESCRIBE INPUT USING clause |
| 209 |
22.4 Implicit DESCRIBE OUTPUT USING clause |
| 213 |
22.5 Implicit EXECUTE USING and OPEN USING clauses |
| 216 |
22.6 Implicit FETCH USING clause |
| 220 |
22.7 Character string retrieval |
| 221 |
22.8 Binary string retrieval |
| 222 |
22.9 Tables used with SQL/MED |
| 233 |
23 Foreign-data wrapper interface routines
23.1 |
| 238 |
23.2 invocation |
| 240 |
23.3 AdvanceInitRequest |
| 241 |
23.4 AllocQueryContext |
| 242 |
23.5 AllocWrapperEnv |
| 244 |
23.6 Close |
| 245 |
23.7 ConnectServer |
| 247 |
23.8 FreeExecutionHandle |
| 249 |
23.9 FreeFSConnection |
| 250 |
23.10 FreeQueryContext |
| 251 |
23.11 FreeReplyHandle |
| 252 |
23.12 FreeWrapperEnv |
| 253 |
23.13 GetNextReply |
| 254 |
23.14 GetNumReplyBoolVE |
| 255 |
23.15 GetNumReplyOrderBy |
| 256 |
23.16 GetNumReplySelectElems |
| 257 |
23.17 GetNumReplyTableRefs |
| 258 |
23.18 GetOpts |
| 260 |
23.19 GetReplyBoolVE |
| 261 |
23.20 GetReplyCardinality |
| 262 |
23.21 GetReplyDistinct |
| 263 |
23.22 GetReplyExecCost |
| 264 |
23.23 GetReplyFirstCost |
| 265 |
23.24 GetReplyOrderElem |
| 266 |
23.25 GetReplyReExecCost |
| 267 |
23.26 GetReplySelectElem |
| 268 |
23.27 GetReplyTableRef |
| 269 |
23.28 GetSPDHandle |
| 270 |
23.29 GetSRDHandle |
| 271 |
23.30 GetStatistics |
| 273 |
23.31 GetWPDHandle |
| 274 |
23.32 GetWRDHandle |
| 275 |
23.33 InitRequest |
| 279 |
23.34 Iterate |
| 281 |
23.35 Open |
| 282 |
23.36 ReOpen |
| 283 |
23.37 Execution of Open |
| 287 |
23.38 TransmitRequest |
| 290 |
23.39 AllocDescriptor |
| 291 |
23.40 FreeDescriptor |
| 292 |
23.41 GetAuthorizationId |
| 293 |
23.42 GetBoolVE |
| 294 |
23.43 GetDescriptor |
| 296 |
23.44 GetDistinct |
| 297 |
23.45 GetNumBoolVE |
| 298 |
23.46 GetNumChildren |
| 299 |
23.47 GetNumOrderByElems |
| 300 |
23.48 GetNumRoutMapOpts |
| 301 |
23.49 GetNumSelectElems |
| 302 |
23.50 GetNumServerOpts |
| 303 |
23.51 GetNumTableColOpts |
| 305 |
23.52 GetNumTableOpts |
| 306 |
23.53 GetNumTableRefElems |
| 307 |
23.54 GetNumUserOpts |
| 308 |
23.55 GetNumWrapperOpts |
| 309 |
23.56 GetOrderByElem |
| 310 |
23.57 GetRoutMapOpt |
| 312 |
23.58 GetRoutMapOptName |
| 314 |
23.59 GetRoutineMapping |
| 315 |
23.60 GetSelectElem |
| 316 |
23.61 GetSelectElemType |
| 317 |
23.62 GetServerName |
| 318 |
23.63 GetServerOpt |
| 320 |
23.64 GetServerOptByName |
| 322 |
23.65 GetServerType |
| 323 |
23.66 GetServerVersion |
| 324 |
23.67 GetSQLString |
| 325 |
23.68 GetTableColOpt |
| 327 |
23.69 GetTableColOptByName |
| 329 |
23.70 GetTableOpt |
| 330 |
23.71 GetTableOptByName |
| 332 |
23.72 GetTableRefElem |
| 333 |
23.73 GetTableRefElemType |
| 334 |
23.74 GetTableRefTableName |
| 335 |
23.75 GetTableServerName |
| 336 |
23.76 GetTRDHandle |
| 337 |
23.77 GetUserOpt |
| 339 |
23.78 GetUserOptByName |
| 341 |
23.79 GetValExprColName |
| 342 |
23.80 GetValueExpDesc |
| 343 |
23.81 GetValueExpKind |
| 344 |
23.82 GetValueExpName |
| 345 |
23.83 GetValueExpTable |
| 346 |
23.84 GetVEChild |
| 347 |
23.85 GetWrapperLibraryName |
| 348 |
23.86 GetWrapperName |
| 349 |
23.87 GetWrapperOpt |
| 351 |
23.88 GetWrapperOptByName |
| 353 |
23.89 SetDescriptor |
| 358 |
23.90 GetDiagnostics |
| 362 |
24 Information Schema
24.1 Information Schema digital artifact
24.2 ATTRIBUTES view |
| 363 |
24.3 COLUMN_OPTIONS view |
| 364 |
24.4 COLUMNS view |
| 365 |
24.5 FOREIGN_DATA_WRAPPER_OPTIONS view |
| 366 |
24.6 FOREIGN_DATA_WRAPPERS view |
| 367 |
24.7 FOREIGN_SERVER_OPTIONS view |
| 368 |
24.8 FOREIGN_SERVERS view |
| 369 |
24.9 FOREIGN_TABLE_OPTIONS view |
| 370 |
24.10 FOREIGN_TABLES view |
| 371 |
24.11 ROUTINE_MAPPING_OPTIONS view |
| 372 |
24.12 ROUTINE_MAPPINGS view |
| 373 |
24.13 USER_MAPPING_OPTIONS view |
| 374 |
24.14 USER_MAPPINGS view |
| 375 |
24.15 Short name views |
| 379 |
25 Definition Schema
25.1 Definition Schema digital artifact
25.2 COLUMN_OPTIONS base table |
| 381 |
25.3 DATA_TYPE_DESCRIPTOR base table |
| 388 |
25.4 FOREIGN_DATA_WRAPPER_OPTIONS base table |
| 389 |
25.5 FOREIGN_DATA_WRAPPERS base table |
| 390 |
25.6 FOREIGN_SERVER_OPTIONS base table |
| 391 |
25.7 FOREIGN_SERVERS base table |
| 392 |
25.8 FOREIGN_TABLE_OPTIONS base table |
| 393 |
25.9 FOREIGN_TABLES base table |
| 394 |
25.10 ROUTINE_MAPPING_OPTIONS base table |
| 395 |
25.11 ROUTINE_MAPPINGS base table |
| 396 |
25.12 SQL_SIZING base table |
| 397 |
25.13 TABLES base table |
| 398 |
25.14 USAGE_PRIVILEGES base table |
| 399 |
25.15 USER_MAPPING_OPTIONS base table |
| 400 |
25.16 USER_MAPPINGS base table |
| 401 |
26 Status codes
26.1 SQLSTATE |
| 404 |
27 Conformance
27.1 Claims of conformance to SQL/MED
27.2 Additional conformance requirements for SQL/MED |
| 407 |
A SQL Conformance Summary |
| 425 |
B Implementation-defined elements |
| 439 |
C Implementation-dependent elements |
| 444 |
D SQL optional feature taxonomy |
| 446 |
E Deprecated features |
| 447 |
F Incompatibilities with ISO/IEC 9075:2016 |
| 448 |
G Defect reports not addressed in this edition of this document |
| 449 |
H Typical header files
H.1 C Header File SQLCLI.H |
| 450 |
H.2 COBOL Library Item SQLCLI |
| 452 |
I SQL/MED model |
| 456 |
Bibliography |
| 457 |
Index |
