SAP DB:ODBC Specifiche Pagina 177
- Pagina / 196
- Indice
- SEGNALIBRI
Valutato. / 5. Basato su recensioni clienti
Data type conversion reference
14.1 Data type conversion
In the information design tool, data foundations expose tables from one or more relational databases,
which are the basis for business layers. The data type associated with each table column is displayed
in a data foundation with other column details. Business layers expose table columns as metadata
objects, like dimensions and hierarchies, and display the data type associated with each object. The
following table describes the mapping between these two sets of data types:
Data type shown in the business layerData type shown in the data foundation
BLOBBINARY, LONGVARBINARY, VARBINARY
BooleanBIT
DateDATE
DateTimeTIME, TIMESTAMP
Long TextLONGVARCHAR
Numeric
BIGINT, DECIMAL, DOUBLE, FLOAT, INTEGER,
NUMERIC, REAL, SMALLINT, TINYINT
StringCHAR, VARCHAR, XML
UnknownUNDEFINED
Note:
From any database, a time is managed as a DateTime in the SAP BusinessObjects Business Intelligence
platform. The date part of the DateTime should be normally displayed as the current date in end-user
reports.
2012-03-15177
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.it. Tutti i diritti riservati | 0.126 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commenti su questo manuale