This graphic is explained in the accompanying text Python: Example 3 Locate the document in its SAP Library structure

Example of calling the Loader with Python Script

Create a database session
Log on to the database instance
Query whether table exists by querying the error code
Create a table without querying error code
Log off

 

# Reference to the Python Libraries
# ---------------------------------

import sys
import loader

# Parse the call arguments
# ------------------------

userid = sys.argv [1]
password = sys.argv [2]
database_name = sys.argv [3]
data_path = sys.argv[4]
server_node = ''

# Create a database session for the Loader
# ----------------------------------------

session = loader.Loader (server_node, database_name)

# Log on to the database instance
# --------------------------------

session.cmd ('use user %s %s;' % (userid, password))

# Query whether the table exists by querying the error code
# The sql method is used to do this
# -------------------------------------

rc = session.sql("EXISTS TABLE CUSTOMER")

If rc!=0

   # Then branch of the If statement must be indented in Python
   # Create the table CUSTOMER
   # ----------------------------------------------------------

   session.cmd ( """CREATE TABLE CUSTOMER (
                       CNO             FIXED(4),
                       NAME         CHAR(10) ASCII,
                       ZIP             CHAR(5)  ASCII,
                       CITY            CHAR(12)  ASCII,
                       PRIMARY KEY (CNO) """)

session.cmd ("COMMIT")

# End the database session
# ------------------------

del session