SHOW

Syntax

  SH[OW] {DBLIST [data base name]
          INDEX [data base name]
          JOIN [data base name]
          LOCKOPTION [data base name]
          LANG[UAGE]}

Parameters

DBLIST

shows the contents of the data base list. (Refer to the DBLIST= command).

INDEX

shows if a Third Party Indexing (TPI) package has been attached to the data base. If a data base name is not provided, the primary data base will be used.

JOIN

shows the most recent valid JOIN command, if any.

LOCKOPTION

shows the current state of LOCKOPTION which can be reset with the ASSIGN command.

LANGUAGE

is the user language. (Refer to the LANGUAGE= command and Appendix D for more information.)

data base name

is the name of a data base opened with a MULTIDB command. If a name is not specified, QUERY will use the primary data base defined by the DEFINE or DATA-BASE= command.

  >SHOW INDEX TOYDB
  INDEXING = NONE
  >SHOW INDEX MYDB
  INDEXING = SUPERDEX (xxxxxx)  Version: 4.1.4x.2
  >SHOW INDEX TESTDB
  INDEXING = OMNIDEX  Version: 3.05.65
  >SHOW LANGUAGE
  LANGUAGE = NATIVE-3000
  >SHOW DBLIST
  TOYDB,TESTDB
  >SHOW LOCKOPTION
  LOCKOPTION = ON
  >ASSIGN LOCKOPTION=OFF
  >SHOW LOCKOPTION
  LOCKOPTION = OFF