SAP DB:ODBC Specifications Page 190
- Page / 196
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
14.2 Large variable length data limitation
Restriction:
The limitation only relates to Crystal Reports applications.
Due to Data Access layer implementation, the maximum size of a column for large variable length binary
and character data is limited to 16MB for the following data sources:
• IBM DB2 through ODBC
• MS SQL Server through ODBC
• Sybase CTL
If an application user inserts large variable length data larger than 16MB into a report, system
performance may be affected.
14.3 Multisource universes
In the case of a multisource-enabled data foundation, Connection Server data types are converted into
the data types exposed through Data Federation Service.
Data Federation data types are the following:
• BIT
• DATE
• TIME
• TIMESTAMP
• DOUBLE
• DECIMAL
• INTEGER
• VARCHAR
They are mapped to the corresponding data foundation data types.
Caution:
BINARY, VARBINARY, and LONGVARBINARY types are not supported and values of these types are
mapped to NULL.
2012-03-15190
Data type conversion reference
- 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
© 2020, manymanuals.com. All rights reserved. | 0.031 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals