SAP DB:ODBC Specifications download pdf (Page 176)

13.1.37 UNION_IN_SUBQUERY

Specifies if the database supports the use of the UNION set operation in sub-

queries.

Description

YES: the database supports the UNION set operation in subqueries.

NO: the database does not support the UNION set operation in subqueries.

Values

2012-03-15176

PRM parameter reference

1 2 ... 171 172 173 174 175 176 177 178 179 180 181 ... 195 196

Data Access Guide 1
2012-03-154 4
2012-03-155 5
2012-03-156 6
2012-03-157 7
2012-03-158 8
2012-03-159 9
2012-03-1510 10
Contents 10
Document History 11
DateVersion 12
2.2 Audience of the guide 13
2.3 What's new? 13
2.4 Key tasks 14
2.5 Conventions of the guide 15
2012-03-1516 16
Introduction to data access 17
3.2.1 System architecture 18
3.2.2 Data access drivers 18
2012-03-1519 19
2012-03-1520 20
3.4 Deployment mode 21
3.5 Connectivity services 22
2012-03-1523 23
2012-03-1524 24
4.1.1 64-bit UNIX support 25
2012-03-1526 26
4.2 Single sign-on support 27
4.3 Stored procedures 28
2012-03-1529 29
2012-03-1530 30
4.4 Connection pools 31
4.5 Load balancing 32
4.5.1 Finding the best server 33
4.5.2 Load balancing logic 34
4.5.3 Backward compatibility 34
4.6 Memory allocation 34
4.6.1 To enable HOARD 35
4.6.2 To disable HOARD 35
2012-03-1536 36
Creating a connection 37
2012-03-1538 38
5.2.2 To run the cscheck tool 39
5.2.4 Check tool—list 40
2012-03-1541 41
5.2.6 Check tool—find 42
2012-03-1543 43
5.2.7 Check tool—middleware 44
5.2.8 Check tool—accessdriver 45
5.2.9 Check tool—connectivity 46
5.2.10 Check tool—ping 47
2012-03-1548 48
5.3 Creating JDBC connections 49
2012-03-1550 50
2012-03-1551 51
2012-03-1552 52
2012-03-1553 53
2012-03-1554 54
2012-03-1555 55
2012-03-1556 56
2012-03-1557 57
5.5 Creating ODBC connections 58
2012-03-1559 59
2012-03-1560 60
2012-03-1561 61
2012-03-1562 62
Data access driver reference 63
6.1.2 File location 64
6.1.3 Table mapping 65
6.1.4 Schema detection 66
2012-03-1567 67
6.2 SAP ERP connections 68
6.2.1 Driver capabilities 68
2012-03-1569 69
2012-03-1570 70
2012-03-1571 71
2012-03-1572 72
6.2.4 ERP limitations 73
2012-03-1574 74
Connection reference 75
7.2 IBM DB2 connections 76
7.4 Oracle EBS connections 77
7.6 Oracle RAC connections 78
7.8 SAP HANA connections 79
7.8.1 Creating a connection 79
2012-03-1580 80
DescriptionOption 81
2012-03-1582 82
7.9 SAP MaxDB connections 83
Data Federation 84
Administration Tool Guide 84
7.11 SAS connections 85
2012-03-1586 86
2012-03-1587 87
2012-03-1588 88
2012-03-1589 89
2012-03-1590 90
Intelligence Rich Client 91
2012-03-1592 92
Caution: 93
2012-03-1594 94
9.1 About global parameters 95
2012-03-1596 96
9.4.1 Charset List Extension 97
9.4.2 Config File Extension 97
9.4.3 Description Extension 97
9.4.5 Load Drivers On Startup 98
9.4.6 Max Pool Time 99
9.4.7 Setup File Extension 100
9.4.8 SQL External Extension 100
9.4.9 SQL Parameter Extension 100
9.4.10 Strategies Extension 101
9.4.12 Validate XML Streams 102
2012-03-15103 103
9.9 Activating traces 104
2012-03-15105 105
9.9.3 Reading traces 106
2012-03-15107 107
2012-03-15108 108
2012-03-15109 109
10.1.2 Installed SBO files 110
Sub-directory 111
SBO fileDatabase technology 112
Teradata 112
10.1.4 To customize SBO files 115
2012-03-15116 116
10.1.6 JDBC driver properties 117
2012-03-15118 118
2012-03-15119 119
2012-03-15120 120
SBO parameter reference 121
2012-03-15122 122
11.3 Common SBO parameters 123
11.3.1 Array Bind Available 123
11.3.2 Array Bind Size 124
11.3.3 Array Fetch Available 124
11.3.4 Array Fetch Size 125
11.3.6 Catalog Separator 126
11.3.7 CharSet Table 127
11.3.8 Description File 127
11.3.9 Driver Capabilities 128
11.3.10 Driver Name 128
11.3.11 Escape Character 129
11.3.12 Extensions 129
11.3.13 Family 130
11.3.14 Force Execute 130
11.3.16 Include Synonyms 131
11.3.17 Introscope Available 131
11.3.18 Max Rows Available 132
11.3.20 Optimize Execute 133
11.3.21 Owners Available 133
11.3.22 Qualifiers Available 134
11.3.24 Quote Identifiers 135
11.3.25 SQL External File 135
11.3.26 SQL Parameter File 136
11.3.27 SSO Available 136
11.3.28 Strategies File 136
2012-03-15137 137
11.3.30 Type 138
11.3.31 Unicode 138
11.3.32 URL Format 139
11.3.33 XML Max Size 139
11.4 JavaBean SBO parameters 140
11.4.1 JavaBean Class 140
11.5 JCO SBO parameters 140
11.5.1 ERP Max Rows 140
11.6 JDBC SBO parameters 141
11.6.1 Connection Shareable 141
11.6.3 ForeignKeys Available 142
11.6.4 Get Extended Column 143
11.6.5 JDBC Class 143
11.6.6 PrimaryKey Available 144
11.6.7 PVL Available 144
11.6.8 Shared Connection 144
11.7 ODBC SBO parameters 145
11.7.1 CharSet 145
2012-03-15146 146
11.7.4 Empty String 147
11.7.5 ODBC Cursors 147
2012-03-15148 148
11.7.9 V5toV6DriverName 149
11.8 OLE DB SBO parameters 149
11.8.1 Enumerator CLSID 150
11.8.2 Provider CLSID 150
11.9.1 MSOlap CLSID 150
11.10 Open SBO parameters 151
11.10.1 Bucket Split Size 151
11.11 Sybase SBO parameters 152
11.11.1 Driver Behavior 152
11.11.2 Password Encryption 152
11.11.3 Quoted Identifier 153
11.11.4 Recover Errors 153
11.11.5 Text Size 154
12.2 About PRM files 155
2012-03-15156 156
2012-03-15157 157
2012-03-15158 158
PRM parameter reference 159
13.1.2 ANALYTIC_FUNCTIONS 160
13.1.4 DISTINCT 161
13.1.5 EXT_JOIN 161
13.1.6 FULL_EXT_JOIN 162
13.1.7 GROUP_BY 162
2012-03-15163 163
13.1.11 HAVING 164
13.1.12 INNER_JOIN 165
13.1.13 INTERSECT 165
13.1.14 INTERSECT_ALL 166
13.1.15 INTERSECT_IN_SUBQUERY 166
13.1.16 JOIN 166
13.1.17 LEFT_EXT_JOIN 167
13.1.18 LEFT_OUTER 167
13.1.20 MINUS 168
13.1.21 MINUS_ALL 169
13.1.22 MINUS_IN_SUBQUERY 169
13.1.23 ORDER_BY 170
13.1.27 RANK_SUPPORTED 171
13.1.28 RIGHT_EXT_JOIN 172
13.1.29 RIGHT_OUTER 172
13.1.31 SELECT_SUPPORTS_NULL 173
13.1.32 SUBQUERY_IN_FROM 174
13.1.33 SUBQUERY_IN_IN 174
13.1.34 SUBQUERY_IN_WHERE 174
13.1.35 UNION 175
13.1.36 UNION_ALL 175
13.1.37 UNION_IN_SUBQUERY 176
14.1 Data type conversion 177
14.1.1 ABAP 178
14.1.2 CSV files 178
14.1.3 JDBC 179
2012-03-15180 180
Data foundation data type 181
14.1.4 ODBC 182
14.1.5 OLE DB 185
2012-03-15186 186
14.1.6 Oracle OCI 187
14.1.7 Sybase CTL 188
2012-03-15189 189
14.3 Multisource universes 190
More Information 191
LocationInformation Resource 192
2012-03-15193 193
(continued) 194
2012-03-15196 196

Comments to this Manuals

No comments

SAP DB:ODBC Specifications Page 176

Comments to this Manuals