Need the basic functionality

About myself: Oracle,Sybase,MySQL,PostgreSQL,MS SQLSERVER and DB2 DBA/Architect since 1989 (Financial,Communication and Trading
industries).

For the past two months I have been testing and benchmark the SAPDB for our corporate data warehouse.

The basic features need to be added:


 We must need a tool like Oracle's SQLPLUS, the dbmcli could be used for DB management.
 The SQLPLUS like tool (invoked from the command line) will have the following features.
 Like myself, the experienced DBAs won't be conformtable with the WEB/Windows GUI.
 We are the one choosing and prmoting the DBMS for our corporate database platforms.

 desc <table>/<view>  ( Some thing like   SELECT  COLUMNNAME,DATATYPE,LEN,DEC,NULLABLE  from DOMAIN.COLUMNS WHERE TABLENAME = <table
name>)
 show index from table <table name>
 show grants/privileges for <ROLE> <USER> <USER GROUP> ...
 show tables (list all the tables - MySQL style)
 show views  (list all the views)
 OUTPUT the result set in ASCII/HTML with format features like Oracle to a file.


For data warehouse:
(Thanks for the parallel features on index build, DBWrite threads, convertor process etc.)

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

--Jey