New post
Question
· Sep 27, 2019

Using ctrl-c during checking the list of databases

#Beginner #System Administration #Caché

Hi ,

 

I am new to cache and I want to check with the experts to see if using the ctrl-c option while checking the list of databases is valid one or will it cause any issues. Below is my scenario

I use the below command to check the list of database 

 

%SYS>do ^MSU

 1) Create a database
 2) Edit a database
 3) List databases
 4) Delete a database
 5) Mount a database
 6) Dismount a database
 7) Compact globals in a database
 8) Show free space for a database
 9) Show details for a database
10) Recreate a database
11) Manage database encryption
12) Return unused space for a database
13) Compact freespace in a database
14) Defragment globals in a database

Now I used option 3 to list my databases 

and I got a list of databases and below is what I got 

     (Multiple selections allowed: * for all, or list such as 1,4,7-10)
Database directories?
 

but instead of using "Enter" to go back to my previous list which gave me the options like " Create databases, Edit database etc"

I accidentally picked the option 64 and it gave me 

Device :

so in order to return back to the previous command list which had the below options 

1) Create a database
 2) Edit a database
 3) List databases
 4) Delete a database
 5) Mount a database
 6) Dismount a database
 7) Compact globals in a database
 8) Show free space for a database
 9) Show details for a database
10) Recreate a database
11) Manage database encryption
12) Return unused space for a database
13) Compact freespace in a database
14) Defragment globals in a database
 

I entered "CTRL-C"  and it brought me to the list of options which I needed. Can you please let me know will using "CTRL-C" instead of "Enter or return" will it cause any issues 

 

Thank you 

Karthik 

Discussion (3)1
Log in or sign up to continue
Vic Sun · Sep 27, 2019

Hello,

First of all I wonder what version of Caché you are using as ^MSU has been replaced by ^DATABASE for a long time.

That being said, I can't imagine there being any problems with interrupting using ctrl+c. In fact, as you didn't get an <INTERRUPT> error it seems likely that ^MSU/^DATABASE has accounted for a user trying to ctrl+c out and so just returns you to the previous menu.

0 0
Nigel Salm · Sep 29, 2019

Many of the terminal based utilities use '^' <enter> to return to the previous field.  In older versions of the Cache utilities  it really depends on who the developer was who wrote the program as well as which area of the product the program was writtren for. There isn't necessarily consistancy between the developers or functionality of the programs.

Most interactive utilities are now accessed through the %SYSTEM package which is accessed using the notation $system....

e.g. set status=$system.Status.Error(5001,"This is a general Error")

Various configuration items can be accessed through this package and the classes therein.

Another package worth noting is %Dictionary that gives you access to all aspects of class definitions, methods, properties, compiled classes etc...

and finally the package %SYS contains may more system related classes

The only other comment is that many system functions require you to be in the %SYS namespace in order to execute the function you require and will also require that you have sufficient roles assigned to your user account to perform such actions.

0 0