SAP DB:ODBC manuali

Manuali dei proprietari e guide per l'utente per Software SAP DB:ODBC.
We fornisce 5 manuali pdf SAP DB:ODBC per scaricare gratuitamente in base al tipo di documento: Guida di Installazione, Manuale Utente, Guida alla Risoluzione dei Problemi, Specifiche

Sap DB:ODBC Guida di Installazione (225 pagine)

Marchio: Sap | Categoria: Software | Dimensione: 3.25 MB |

Inglese

Indice

ODBC Database Interface

1

Contents

3

1.2 Features

24

1.3 Requirements

26

Mac OS X

27

2. Installation

28

Operating System Platform

29

Python Build Version

29

2.2.1 Prerequisites

30

2.2.2 Before You Start

30

License Files

31

Step 1

31

2.2.4 Uninstall

32

2.3.2 Before You Start

33

Step 2

34

Step 3

35

Step 4

35

2.4.1 Before You Start

36

2.3.4 Uninstall

36

2.4.3 Uninstall

38

Manual Uninstall

39

3.1 ODBC Application Stack

40

[Microsoft][ODBC Driver

42

Windows Registry Keys

43

3.2.6 DSN-less Connections

45

[ODBC Data Sources]

49

[ODBC Drivers]

50

ODBCINI

50

ODBCINSTINI

50

3.3.7 DSN-less Connections

52

DNS-less Connection String

53

4.1 MS SQL Server

54

Driver Limitations

58

[MONET]

60

4.1.2 General Notes

61

Access Violations

63

Kerberos on Linux

64

4.2 MS Access Database

65

4.3 Oracle

65

Driver Notes

66

4.4 IBM DB2

68

4.4.2 General Notes

69

Linker Paths

70

4.5 Sybase ASE

71

4.6 PostgreSQL

73

4.7 MySQL

75

.rownumber to the

76

.rownumber

76

4.8 SAP MaxDB / SAPDB

77

4.9 Teradata

78

ORDER BY clause to

80

4.10 Netezza

81

Netezza and Unicode

82

4.11 Other Databases

83

5. mxODBC Overview

85

5.1.2 Extensions

86

5.3 Supported ODBC Versions

87

5.5 Transaction Support

88

5.5.2 Manual Commit

89

5.6 Stored Procedures

90

Methods

91

parametertypes Parameter

93

5.7 Introspection

98

5.8 ODBC Cursor Types

100

5.8.2 Default Cursor Type

101

MS SQL Server

102

Oracle

102

Factory Functions

103

Predefined Row Factories

105

5.10 mxODBC Subpackages

107

6.2 Connection Type Object

109

6.1 Subpackage Support

109

6.6 Unicode/ANSI Connections

113

# string

114

7. mxODBC Cursor Objects

124

7.2 Subpackage Support

125

7.4 Cursor Type Object

125

7.6 Cursor Object Methods

126

7.6.1 Catalog Methods

135

Common Interface

136

Result Set Layouts

136

Search Pattern Parameters

136

Unicode

137

Available Catalog Methods

137

SQLBindCol()

138

SQLGetData() and

138

7. mxODBC Cursor Objects

139

.gettypeinfo(sqltype)

142

7.7 Cursor Object Attributes

156

Per-Statement Binding Mode

164

8.3 SQL Type Input Binding

165

UNICODE_STRINGFORMAT

166

None singleton is

168

8.5 Output Conversions

171

EIGHTBIT_STRINGFORMAT

172

8.7 Auto-Conversions

175

8.9 Additional Comments

177

Handling

180

10.2 SQL Error Mappings

182

10.4 Error Handlers

183

10.4.2 Examples

184

10.5 Warning Classes

185

10.6 Database Warnings

185

11. mxODBC Functions

188

11.2 mx.ODBC Functions

189

Classes

193

Functions

193

Driver Manager

195

14.4 mx.ODBC.iODBC

197

Manager

197

14.5.1 Notes

199

64-bit Platforms

200

14.7 ODBC Driver Subpackages

202

Running mxODBC with mod_wsgi

204

Freezing mxODBC using py2exe

205

16. Examples

207

18. mxODBC Package Structure

210

19.1.1

211

Windows ODBC Manager

211

19.1.2 iODBC Driver Manager

212

20. History & Changes

214

21. Copyright & License

215

Version 1.3.0

216

1. Introduction

216

2. Terms and Definitions

216

3. License Grant

217

4. Authorizations

217

5. Modifications

218

8. NO WARRANTY

218

9. LIMITATION OF LIABILITY

218

10. Termination

219

11. Indemnification

219

12. Third Party Rights

219

13. High Risk Activities

219

14. General

220

15. Agreement

220

1 CPU License (Example)

221

1. License Grant

221

2. Covered Software

221

3. Authorizations

221

4. Proof

222

7.2 Redistribution

224

8. Proof

224

21. Copyright & License

225

Sap DB:ODBC Manuale Utente (7 pagine)

Marchio: Sap | Categoria: Software | Dimensione: 0.27 MB |

Inglese

Indice

Abstract

2

Supported Versions

2

Table of Contents

2

Overview

2

Tool, or Developer Tool

5

Authors

7

Acknowledgements

7

Sap DB:ODBC Guida alla Risoluzione dei Problemi (124 pagine)

Marchio: Sap | Categoria: Software | Dimensione: 0.78 MB |

Inglese

Indice

Replication Server

1

Contents

3

Conventions

9

TableName

10

CHAPTER 1: Conventions

11

4 Replication Server

12

How to Use This Document

13

6 Replication Server

14

ASE-to-SAP HANA Database

15

Replication Setup

15

Planning Your Installation

16

%SYBASE%

17

Installing Replication Server

18

SySAM Users Guide

20

SAMPLE_RS_ra

25

22 Replication Server

30

Oracle-to-SAP HANA Database

31

Prerequisites

32

./ra.sh -v

39

[dataservername]

40

Guide and Reference Guide

47

<repdefname>

56

You see:

57

50 Replication Server

58

Microsoft SQL Server-to-SAP

59

HANA Database Replication

59

RACFGFilePath

72

SQLInstanceName

74

Subsequent initialization

77

-r parameter. For example:

80

78 Replication Server

86

DB2 UDB-to-SAP HANA

87

Database Replication Setup

87

# force 32-bit libraries

96

Configuring Replication Agent

100

LIST TABLESPACES

102

SHOW DETAIL command

102

Replication

103

Agent Administration Guide

103

/etc/services

104

96 Replication Server

104

Setting DB2 UDB Environment

105

Variables

105

-vr parameter

105

Testing Replication

110

Glossary

113

CHAPTER 7: Glossary

120

112 Replication Server

120

114 Replication Server

122

116 Replication Server

124

Sap DB:ODBC Manuale Utente (49 pagine)

Marchio: Sap | Categoria: Software | Dimensione: 6.21 MB |

Inglese

Indice

Sap DB:ODBC Specifiche (196 pagine)

Marchio: Sap | Categoria: Software | Dimensione: 1.41 MB |

Inglese

Indice

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

SAP dispositivi