2004.07.02 MaxDB™ by MySQL 7.5.00.15 Released

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