The UniVerse Command Processor - SQL Database

The UniVerse Command Processor

UniVerse is an integrated database management and application development system that runs on the UNIX and Windows platforms. Some of the more powerful features of UniVerse are the following:

  • Variable table sizes, row lengths, column sizes, and number of columns
  • Unlimited number of tables and files
  • Several table access methods for the most efficient data storage, access, and retrieval
  • Database facilities that let you create associations among columns in a table or file
  • A dictionary-driven, interactive data entry processor for editing data in tables and files
  • Online help for any command in most of the command languages
  • SQL data definition and retrieval language
  • Facilities to save SQL statements and UniVerse commands for future use and to create stored command sequences
  • A powerful programming language (UniVerse BASIC) with built-in database management extensions, including the ODBC-based BASIC SQL Client Interface (BCI)
  • Client/server access (UCI (Uni Call Interface), UniVerse ODBC, BASIC SQL Client Interface (BCI), InterCall, UniObjects, UniObjects for Java, and UniOLEDB)

The UniVerse command processor accepts statements and commands from the terminal or other sources and either processes the command itself or calls another UniVerse or system process. When you first enter the UniVerse environment, the command processor is in control of the terminal.

The command processor interprets SQL statements and UniVerse commands, performs certain substitutions on statement and command lines, and passes control to the proper process or utility. Other UniVerse processors, such as the UniVerse Editor, ProVerb, and ReVise, offer sets of commands tailored to their specific functions. UniVerse also supports a procedural language that allows you to write a program, compile it, and then execute it. In addition to its own functions, UniVerse provides easy access to the operating system.

UniVerse SQL

Other UniVerse Utilities and Processors:

Using UniVerse SQL you can query and update data in UniVerse tables and files. You can use UniVerse SQL interactively and in local and remote client programs.
UniVerse SQL provides the following enhancements to the UniVerse environment:

  • Subqueries that let you nest queries
  • Relational joins that let you work with data from more than one table or file in a single statement
  • Added database security and integrity

UniVerse SQL conforms to the ANSI/ISO 1992 standard established for SQL, enhanced to take advantage of the extended relational database structure of UniVerse. In contrast to first-normal-form (1NF) databases, which can have only one value for each row and column position (or cell), UniVerse is a nonfirst-normal-form (NF2) database, which can hold multiple values in a cell. UniVerse also supports nested tables called associations, which are made up of a group of related multivalued columns in a table.

The language processors and the run machine call UniVerse utilities and processes to create and delete UniVerse files, display the system status, locate rows in tables and files, control concurrent access to columns or tables, check table size, and so on. UniVerse also calls on system processes and utilities for certain tasks. These utilities and processes are documented in UniVerse System Description and the UniVerse User Reference.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SQL Database Topics