SAP DB is now SAP MaxDB! For more information, visit the SAP MaxDB pages in the SAP Developer Network.

Module sapdb.loader (Python)

• Loader: Opens a connection.
• cmd: Executes a command and returns resulting buffer as a string.
• rawCmd; Executes a command and returns resulting buffer as a string without checking for errors.
• sql: Executes an SQL statement and returns the error code.
• release: Closes the connection.

Installation

Examples

Exceptions

• CommunicationError
• RepManServError

constructor Loader

session = loader.Loader (server_node, database_name)

Opens a connection. An empty server node will search for a Loader Server on the local machine.

cmd

output = session.cmd (cmd)

Executes a command and returns resulting buffer as string. Any error will result in an exception. For the format of the paramter $cmd please see the documentation of the SAP DB Loader.

rawCmd

output = session.rawCmd (cmd)

Executes a command and returns resulting buffer as string without checking for errors. For the format of the paramter $cmd please see the documentation of the SAP DB Loader.

sql

result = session.sql (cmd)

Executes an SQL statement and returns the error code. This method does not raise an exception unless an error occurs that is not related to this SQL statement.

release

session.release ()

Closes the connection.

Add <dependent_path>/misc to the PYTHONPATH.

Examples for all methods: egLoader.py

• CommunicationError:
  
  The communication link to the server failed. The exception value is an instance with the following attributes:
  • errorCode
  • message
  • RepManServError
  
  
  
• RepManServError:
  
  The execution of the command on the server resulted in an error. The exception value is an instance with the following attributes:
  • errorCode
  • message
  • sqlCode (when an SQL statement failed)
  • sqlMessage (when an SQL statemen failed)

This site is sponsored by SAP AG.