Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    8

    Unanswered: is there any tools in MAXDB can run sql statement with command line?

    hi all

    is there a tool in maxdb can run sql statement with command line??

    for example,i wanna create a table using sql statement with command line
    "create table person(
    name char(20),
    age number,
    address char(100),
    phone number(10)
    );"

    just like SQLPLUS in ORACLE

    can i find it in maxdb???

    need ur help
    thx
    Last edited by jumbo6; 04-07-04 at 03:28.

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Re: is there any tools in MAXDB can run sql statement with command line?

    Originally posted by jumbo6
    hi all

    is there a tool in maxdb can run sql statement with command line??

    for example,i wanna create a table using sql statement with command line
    "create table person(
    name char(20),
    age number,
    address char(100),
    phone number(10)
    );"

    just like SQLPLUS in ORACLE

    can i find it in maxdb???

    need ur help
    thx
    You can use DBMCLI with a sql session
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Mar 2004
    Posts
    8

    r u sure?

    but i read this from maxdb help document:

    "The Database Manager CLI is the client program of the Database Manager, which enables you to connect to the DBM Server and exchange data with it."

    so i guess DBMCLI is a tool samiler "mysqladmin" in mysql.

    and i have already used it to create and configurate an instance.

    after that i used LOADERCLI to create my usergroups and my users.

    now i wanna find a tool which like "mysql" in Mysql or "sqlplus" in Oracle.
    i need this tool to use DML and DDL sql statement in Maxdb.

    my os : Linux
    my db: Maxdb 7.5.0.8
    Last edited by jumbo6; 04-09-04 at 12:57.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •