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: object of the SAPDB_ResultSet class
   # ----------------------------------------------
   cursor = session.sql (select)
   #
   # The getDescription method returns
   # a list of the column descriptions.
   # ----------------------------------------------
   descriptions = cursor.getDescription ()
   for description in descriptions:
     print '======================='
     # Column name
     print 'Name:', description [0]
     # Type of the column as a string
     print 'Type:', description [1]
     # Type of the column as an integer
     print 'Type:', description [2]
     # Column length
     print 'Len:', description [3]
     # Number of decimal places
     print 'Frac:', description [4]
     # Result set columns are always required columns.
     print 'Mandatory:', description [5]
     # Result set columns are always output.
     print 'in/out:', description [6]
   #
   # Close the session with the database
   # --------------------------------------------
   session.release ()