Differences between revisions 5 and 8 (spanning 3 versions)

SAP DB (MaxDB)

URL for 7.6 and later: http://www.sdn.sap.com/irj/sdn/maxdb
URL for 7.5: (was http://www.mysql.org/products/maxdb/, but is no longer available)
URL for 7.3 and 7.4: http://www.sapdb.org/
licence: GPL
platforms: Linux/i386, Solaris, HP-UX, AIX, Dec, Windows

DB API 2.0 Drivers

sapdbapi

URL: http://www.sapdb.org/sap_db_program.htm
licence: LGPL
platforms: see SAP DB
Python versions: 1.5.2 - 2.2

mxODBC

URL: http://www.egenix.com/products/python/mxODBC/
Licence: eGenix.com Commercial License
Platforms: Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
Python versions: 2.1 - 2.5

SAP DB's native CLI is ODBC compatible and mxODBC can link directly against these libraries on Unix. It also supports the SAPDB ODBC driver on Windows.

Other Drivers

sapdb

URL: http://www.sapdb.org/sap_db_program.htm
licence: LGPL
platforms: see SAP DB
Python versions: 1.5.2 - 2.2

Programming Model

cursor = session.sql ("select * from messages")
for msgno, lang, text in cursor:
    print msgno, text

insert = session.prepare ("insert into sometable values (?, ?)")
print insert.getDescription ()
insert.execute (["string", 1])

select = session.prepare ("select * from messages where msgno < :msgno")
cursor = select.execute ([200])
print cursor.next ()
print cursor.relative (100)
print cursor.absolute (4)
print cursor.absolute (-4)

Supported Python Applications

a sapdb driver exists for ["PyDO"] (Python Data Objects)

-  ⇤ ← Revision 5 as of 2005-10-10 06:14:20 → 
  Size: 228
  Editor: 62
  Comment:
+   ← Revision 8 as of 2008-02-18 17:41:33 → ⇥
  Size: 1654
  Editor: MarcAndreLemburg
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 1:
-The Best monitor Directory on the Web
+#pragma section-numbers off
 Line 3:
-http://www.monitordirectory.vip.su
+= SAP DB (MaxDB) =
 Line 5:
-Monitor Directory has delivered to the market scores of standard and custom products and software solutions.
+  URL for 7.6 and later:: http://www.sdn.sap.com/irj/sdn/maxdb
  URL for 7.5:: (was http://www.mysql.org/products/maxdb/, but is no longer available)
  URL for 7.3 and 7.4:: http://www.sapdb.org/
  licence:: GPL
  platforms:: Linux/i386, Solaris, HP-UX, AIX, Dec, Windows
-Line 7:
+Line 11:
-http://www.monitordirectory.vip.su
+----

== DB API 2.0 Drivers ==

=== sapdbapi ===

  URL:: http://www.sapdb.org/sap_db_program.htm
  licence:: LGPL
  platforms:: see SAP DB
  Python versions:: 1.5.2 - 2.2

=== mxODBC ===

  URL:: http://www.egenix.com/products/python/mxODBC/
  Licence:: eGenix.com Commercial License
  Platforms:: Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
  Python versions:: 2.1 - 2.5

SAP DB's native CLI is ODBC compatible and mxODBC can link directly against these libraries on Unix. It also supports the SAPDB ODBC driver on Windows.

== Other Drivers ==

=== sapdb ===

  URL:: http://www.sapdb.org/sap_db_program.htm
  licence:: LGPL
  platforms:: see SAP DB
  Python versions:: 1.5.2 - 2.2

==== Programming Model ====

{{{
cursor = session.sql ("select * from messages")
for msgno, lang, text in cursor:
    print msgno, text

insert = session.prepare ("insert into sometable values (?, ?)")
print insert.getDescription ()
insert.execute (["string", 1])

select = session.prepare ("select * from messages where msgno < :msgno")
cursor = select.execute ([200])
print cursor.next ()
print cursor.relative (100)
print cursor.absolute (4)
print cursor.absolute (-4)
}}}

----

== Supported Python Applications ==

 * a sapdb driver exists for ["PyDO"] (Python Data Objects)

Page

User