RE: Need the basic functionality

>  We must need a tool like Oracle's SQLPLUS, the dbmcli could 
> be used for DB management.

Have a look at <dependent_path>/bin/ireport.py. This is a Python script that does
many of the things you want from SQLPlus and is easily extended to do more.

call it as
$ <dependent_path>/bin/x_python  <dependent_path>/bin/ireport.py
This should set everything up as required.

You could also use your own Python, in which case you'll have to download the Python package from sapdb.org (to supprt Python 2.*). This has the advantage that you could handle Unicode data and that you could use readline support.

ireport.py -h gives the options, -tutorial starts a crude tutorial, and 'help' inside the tool lists the commands.

>  desc <table>/<view>  ( Some thing like   SELECT  
==> table tablename
does that. The current version requires that the tablename is entered case sensitive, one of the next versions will query the database for the right spelling.

>  OUTPUT the result set in ASCII/HTML with format features 
> like Oracle to a file.

It's got several formats and is easily extended to support more.

> One very important feature 'table and index partitioning' 
> must be added to manage the large databases.

This one is on and off in our planning. I'll ask about the current state.

Daniel Dittmar

-- 
Daniel Dittmar
SAP DB, SAP Labs Berlin
[email protected]
http://www.sapdb.org/