Syntax

1. #
   # Import Python modules
   # -------------------------------------------
   import sys
   import sdb.sql
   # Connect to the database
   # -------------------------------------------
   database_user = sys.argv [1]
   database_user_password = sys.argv [2]
   database_name = sys.argv [3]
   session = sdb.sql.connect (database_user, database_user_password, database_name)
   select = """
     SELECT title, name, cno FROM hotel.customer
     WHERE cno BETWEEN 3000 AND 8000"""
   #
   # Execute a SELECT statement
   # Result: An object of the SapDB_ResultSet class
   # -----------------------------------------------
   cursor = session.sql (select)
   #
   # The next method reads the next data record
   # in the result set.
   # When the last row of the result set is reached,
   # the next method returns the value 'None'.
   # -----------------------------------------------
   row = cursor.next ()
   while row:
     title, name, cno = row
     print "%s %s %d" % (title, name, cno)
     row = cursor.next ()
   #
   # Close connection to the database
   # ---------------------------------------------
   session.release ()