Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

intro(8sql)

intro(1sql)

Name

intro − Introduction to ULTRIX/SQL commands in Section 1

Description

ULTRIX/SQL is a relational database management system provided with the ULTRIX operating system.  This reference page lists and briefly summarizes ULTRIX/SQL operating system commands available to ULTRIX/SQL general users, database administrators (owners), or both. 

auditdb
Print selected portions of the database journal or create an audit trail of changes made to a particular table.

catalogdb
List databases that you own, your user capabilities, and database locations and extensions.

ckpdb
Create a checkpoint (backup) for a database, and enable or disable journaling.

copydb
Create command procedures to copy a database to data files and then restore the database from those files.

createdb
Create a database.

destroydb
Delete a database and remove all references to it in the ULTRIX/SQL system.

finddbs
Recover the ULTRIX/SQL master database when it is corrupted or missing entries for user databases.

isql
Invoke the interactive forms-based utility for querying and updating databases.

optimizedb
Generate statistics for use by the ULTRIX/SQL query optimizer.

rollforwarddb
Recover a database from the last checkpoint and current journal.

sql Invoke the ULTRIX/SQL Terminal Monitor, a command line interface for entering SQL statements. 

unloaddb
Create command procedures to unload a database (including system tables) into data files and then recreate and reload the database from those files.

See Also

intro(8sql)

Typewritten Software • bear@typewritten.org • Edmonds, WA 98026