CSDN博客

img naxin

2004.07.02 MaxDB™ by MySQL 7.5.00.15 Released

发表于2004/7/3 1:33:00  883人阅读

分类: 03. Database 技术

2004.07.02 MaxDB? by MySQL 7.5.00.15 Released

http://lists.mysql.com/announce/205

*********************************************

localhost:7210??????????????????????????? by naxin.

*********************************************

First Steps with SAP DB

Setting the environment

  1. Execute the script sapdbenv to set the environment.
    c:/>sapdbenv.cmd

Starting and stopping the database

  1. Is the database running?
    $ dbmcli -d TST -u DBM,DBM db_state
    Output ?
    OK
    State
    ONLINE
    ONLINE state:
    (the database is accepting connections)
    OK
    State
    ADMIN
    ADMIN state:
    (the database is accepting only administration requests
    OK
    State
    OFFLINE
    OFFLINE state:
    (the database is not started)
    ERR
    ...
    some error occurred
    (was the dabase name and the user spelled correctly?)

    After installation, the demo database should be in in state WARM.

  2. Stopping the database
    $ dbmcli -d TST -u DBM,DBM db_offline
    Output ?
    OK the database has been stopped
    ERR
    ...
    some error occurred

    All databases should be stopped using this command before a shutdown. Otherwise, loss of data may occurr.

Starting the database
$ dbmcli -d TST -u DBM,DBM db_warm

Output ?
OK the database has been started
ERR
...
some error occurred

?

?

?

?SQLCLI.exe

The SQLCLI is a database tool that enables database users to perform the following tasks:

·??????? Access data

·??????? Access the database catalog

·??????? Make SQL queries

·??????? Create and manage database objects

·??????? Create and manage database users

Syntax

sqlcli [–n ] [-d ] [-u database_user>,] [sqlcli_command|sql_command]

sqlcli_command

SQLCLI command

sql_command

SQL statement

To get a list of all SQLCLI commands and their options, use the following command:

sqlcli /h

Examples

Querying general information about the database HOTELDB as user MONA with the password RED:

sqlcli –d HOTELDB –u MONA,RED /s

Displaying all data records in the table customer in the database HOTELDB as user MONA with the password RED:

sqlcli -d HOTELDB -u MONA,RED SELECT * FROM customer

阅读全文
0 0

相关文章推荐

img
取 消
img