Difference between revisions of "SET AUTOCATALOG"

From Recital Documentation Wiki
Jump to: navigation, search
(See Also)
 
(10 intermediate revisions by 3 users not shown)
Line 1: Line 1:
=SET AUTOCATALOG=
 
 
 
==Class==
 
Databases
 
 
 
 
==Purpose==
 
==Purpose==
 
Enable files to be automatically added to a database catalog
 
Enable files to be automatically added to a database catalog
Line 12: Line 5:
 
==Syntax==
 
==Syntax==
 
SET AUTOCATALOG ON | OFF | (<expL>)
 
SET AUTOCATALOG ON | OFF | (<expL>)
 +
 
SET AUTOCATALOG TO <database>
 
SET AUTOCATALOG TO <database>
  
  
 
==See Also==
 
==See Also==
[[ALTER INDEX]], [[ALTER TABLE]], [[CLOSE DATABASES]], [[CLOSE TABLES]], [[COMPILE DATABASE]], [[CREATE DATABASE]], [[CREATE INDEX]], [[CREATE TABLE]], [[CREATE VIEW]], [[DISPLAY DATABASE]], [[DISPLAY INDEXES]], [[DISPLAY TABLES]], [[DROP DATABASE]], [[DROP INDEX]], [[DROP TABLE]], [[LIST DATABASE]], [[LIST INDEXES]], [[LIST TABLES]], [[OPEN DATABASE]], [[PACK DATABASE]], [[REBUILD DATABASE]], [[REINDEX DATABASE]], [[USE]], [[SET EXCLUSIVE]], [[ADATABASES()]], [[DBUSED()]], [[DB_MAXWKA]]
+
[[ADATABASES()]], [[ADD TABLE]], [[ALTER INDEX]], [[ALTER TABLE]], [[CLOSE DATABASES]], [[CLOSE TABLES]], [[COMPILE DATABASE]], [[COPY DATABASE]], [[CREATE DATABASE]], [[CREATE INDEX]], [[CREATE TABLE]], [[CREATE VIEW]], [[DBUSED()]], [[DISPLAY DATABASE]], [[DISPLAY INDEXES]], [[DISPLAY SCHEMAS]], [[DISPLAY TABLES]], [[DROP DATABASE]], [[DROP INDEX]], [[DROP TABLE]], [[LIST DATABASE]], [[LIST INDEXES]], [[LIST SCHEMAS]], [[LIST TABLES]], [[OPEN DATABASE]], [[PACK DATABASE]], [[REBUILD DATABASE]], [[REINDEX DATABASE]], [[SET EXCLUSIVE]], [[SQL USE|USE]]
 +
 
  
 
==Description==
 
==Description==
 
The SET AUTOCATALOG commands allow tables and their index files to be automatically added to a database catalog.  The database itself should be closed when using the auto catalog commands.  The SET AUTOCATALOG TO <database> command specifies the name of the database for which the catalog should be updated.  SET AUTOCATALOG ON | OFF allows updates to the catalog to be toggled on and off.  Once the auto catalog commands are active, tables and their indexes can be opened from the interactive prompt or from an application and the database catalog will automatically be updated.  For additional details on the information stored in the database catalog, please see the OPEN DATABASE command.
 
The SET AUTOCATALOG commands allow tables and their index files to be automatically added to a database catalog.  The database itself should be closed when using the auto catalog commands.  The SET AUTOCATALOG TO <database> command specifies the name of the database for which the catalog should be updated.  SET AUTOCATALOG ON | OFF allows updates to the catalog to be toggled on and off.  Once the auto catalog commands are active, tables and their indexes can be opened from the interactive prompt or from an application and the database catalog will automatically be updated.  For additional details on the information stored in the database catalog, please see the OPEN DATABASE command.
  
Databases in Recital are implemented as directories containing files that correspond to the tables and associated files in the database.  Operating System file protection can be applied individually to the files for added security.  The directories are sub-directories of the Recital data directory.  The environment variable / symbol DB_DATADIR points to the current Recital data directory.  Databases are opened using the OPEN DATABASE command.  Database commands can be issued as SQL statement commands or as Recital/4GL commands.
+
Databases in Recital are implemented as directories containing files that correspond to the tables and associated files in the database.  Operating System file protection can be applied individually to the files for added security.  The directories are sub-directories of the Recital data directory.  The environment variable / symbol DB_DATADIR points to the current Recital data directory.  Databases are opened using the OPEN DATABASE command.  Database commands can be issued as SQL statement commands or as Recital commands.
  
  
 
==Example==
 
==Example==
<pre>
+
<code lang="recital">
 
close databases
 
close databases
 
set autocatalog to southwind
 
set autocatalog to southwind
 
set autocatalog on
 
set autocatalog on
do myapp</pre>
+
do myapp</code>
 
+
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Set_Commands|AUTOCATALOG]]
 
[[Category:Set_Commands|AUTOCATALOG]]
 +
[[Category:Databases]]
 +
[[Category:Databases Set Commands]]

Latest revision as of 07:12, 12 October 2010

Purpose

Enable files to be automatically added to a database catalog


Syntax

SET AUTOCATALOG ON | OFF | (<expL>)

SET AUTOCATALOG TO <database>


See Also

ADATABASES(), ADD TABLE, ALTER INDEX, ALTER TABLE, CLOSE DATABASES, CLOSE TABLES, COMPILE DATABASE, COPY DATABASE, CREATE DATABASE, CREATE INDEX, CREATE TABLE, CREATE VIEW, DBUSED(), DISPLAY DATABASE, DISPLAY INDEXES, DISPLAY SCHEMAS, DISPLAY TABLES, DROP DATABASE, DROP INDEX, DROP TABLE, LIST DATABASE, LIST INDEXES, LIST SCHEMAS, LIST TABLES, OPEN DATABASE, PACK DATABASE, REBUILD DATABASE, REINDEX DATABASE, SET EXCLUSIVE, USE


Description

The SET AUTOCATALOG commands allow tables and their index files to be automatically added to a database catalog. The database itself should be closed when using the auto catalog commands. The SET AUTOCATALOG TO <database> command specifies the name of the database for which the catalog should be updated. SET AUTOCATALOG ON | OFF allows updates to the catalog to be toggled on and off. Once the auto catalog commands are active, tables and their indexes can be opened from the interactive prompt or from an application and the database catalog will automatically be updated. For additional details on the information stored in the database catalog, please see the OPEN DATABASE command.

Databases in Recital are implemented as directories containing files that correspond to the tables and associated files in the database. Operating System file protection can be applied individually to the files for added security. The directories are sub-directories of the Recital data directory. The environment variable / symbol DB_DATADIR points to the current Recital data directory. Databases are opened using the OPEN DATABASE command. Database commands can be issued as SQL statement commands or as Recital commands.


Example

close databases
set autocatalog to southwind
set autocatalog on
do myapp

Products

Recital Server, Recital