When you call the Database Manager CLI, you can enter various DBM options and exactly one DBM command.
You can enter parameters for many of the DBM options. If you do not specify a parameter, the default values are used.
If you enter DBM options with parameters, you must mark the beginning of the following DBM command with the DBM option –c. In this way you prevent the Database Manager from interpreting the subsequent DBM command as a parameter of the previously entered DBM option.
See also:
Calling the Database Manager CLI
You can use the following DBM options:
Option |
Description |
Indicating as DBM command |
|
Name of database instance |
|
Activating encryption |
|
Name of the input script |
|
Name of the output file |
|
Installation directory of the database instance |
|
Name of the log file |
|
Opening an SQL session |
|
Opening a utility session |
|
Deleting XUSER entries |
|
User key |
|
Creating or changing XUSER entries |
|
Logging on to the XUSER program |
|
Displaying XUSER data |
Log on to the Database Manager CLI as operator OLEG with password MONDAY, connect to the DEMODB database instance, display the contents of the users database system table without explicitly specifying a database user.
You mark the beginning of the DBM command with the option –c. The default value (database system administrator) is used for the database user.
dbmcli -u OLEG,MONDAY -d DEMODB -uSQL –c db_execute SELECT * FROM users
OK
END
'OLEG';'';'OLEG';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'20050602';'0
0104503';'20050602';'00104503';'20050602';'00104503';'DEMODB';'p59963.dhcp.ber.s
ap.corp';0;'NO';(null)
'DBADMIN';'';'DBSERVICE';'DBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'200506
02';'00104508';'20050602';'00104508';'20050602';'00104508';'DEMODB';'p59963.dhcp
.ber.sap.corp';6;'YES';(null)
'DBADMIN';'';'DBADMIN';'SYSDBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20050
602';'00104503';'20050602';'00104506';'20050602';'00104503';'DEMODB';'p59963.dhc
p.ber.sap.corp';10;'NO';(null)
'DBADMIN';'';'MONA';'DBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20050602';'
00104523';'20050602';'00104523';'20050602';'00104523';'DEMODB';'p59963.dhcp.ber.
sap.corp';24;'NO';(null)