Difference between revisions of "Using Recital SQL"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (→Creating a Recital Database) |
Yvonnemilne (Talk | contribs) (→Creating a Recital Database) |
||
| Line 1: | Line 1: | ||
==Using Recital SQL== | ==Using Recital SQL== | ||
===Creating a Recital Database=== | ===Creating a Recital Database=== | ||
| − | The [[CREATE DATABASE|create database]] statement is used to create a new database. This will create a sub-directory in the [[DB_DATADIR]] directory with the same name as the database specified. | + | The [[CREATE DATABASE|create database]] statement is used to create a new database. This will create a sub-directory in the [[DB_DATADIR]] directory and a database catalog with the same name as the database specified. |
| + | |||
| + | <pre> | ||
| + | create database [if not exists] <database name> | ||
| + | </pre> | ||
| + | |||
| + | <code lang="recital"> | ||
| + | <code> | ||
===Opening a Recital Database=== | ===Opening a Recital Database=== | ||
| Line 52: | Line 59: | ||
* PREPARE | * PREPARE | ||
* SYSRESULTSET Used to return the singleton result from any Recital expression | * SYSRESULTSET Used to return the singleton result from any Recital expression | ||
| − | ===Summary=== | + | ===Summary===</code> |
Revision as of 14:47, 21 December 2009
Using Recital SQL
Creating a Recital Database
The create database statement is used to create a new database. This will create a sub-directory in the DB_DATADIR directory and a database catalog with the same name as the database specified.
create database [if not exists] <database name>
<code> ===Opening a Recital Database=== * OPEN DATABASE * USE ===Creating a Recital Table using Recital SQL=== * CREATE TABLE * ALTER TABLE * ALTER INDEX * CREATE INDEX * TABLE CONSTRAINTS * COLUMN CONSTRAINTS ===Inserting Records into a Recital Table using Recital SQL=== * INSERT ===Selecting Records from a Recital Table Using Recital SQL=== * SELECT * DECLARE CURSOR * OPEN * FETCH * DROP CURSOR ===Updating Records in a Recital Table using Recital SQL=== * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * OPEN DATABASE * USE ===Creating a Recital Table using Recital SQL=== * CREATE TABLE * ALTER TABLE * ALTER INDEX * CREATE INDEX * TABLE CONSTRAINTS * COLUMN CONSTRAINTS ===Inserting Records into a Recital Table using Recital SQL=== * INSERT ===Selecting Records from a Recital Table Using Recital SQL=== * SELECT * DECLARE CURSOR * OPEN * FETCH * DROP CURSOR ===Updating Records in a Recital Table using Recital SQL=== * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * USE ===Creating a Recital Table using Recital SQL=== * CREATE TABLE * ALTER TABLE * ALTER INDEX * CREATE INDEX * TABLE CONSTRAINTS * COLUMN CONSTRAINTS ===Inserting Records into a Recital Table using Recital SQL=== * INSERT ===Selecting Records from a Recital Table Using Recital SQL=== * SELECT * DECLARE CURSOR * OPEN * FETCH * DROP CURSOR ===Updating Records in a Recital Table using Recital SQL=== * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * CREATE TABLE * ALTER TABLE * ALTER INDEX * CREATE INDEX * TABLE CONSTRAINTS * COLUMN CONSTRAINTS ===Inserting Records into a Recital Table using Recital SQL=== * INSERT ===Selecting Records from a Recital Table Using Recital SQL=== * SELECT * DECLARE CURSOR * OPEN * FETCH * DROP CURSOR ===Updating Records in a Recital Table using Recital SQL=== * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * ALTER TABLE * ALTER INDEX * CREATE INDEX * TABLE CONSTRAINTS * COLUMN CONSTRAINTS ===Inserting Records into a Recital Table using Recital SQL=== * INSERT ===Selecting Records from a Recital Table Using Recital SQL=== * SELECT * DECLARE CURSOR * OPEN * FETCH * DROP CURSOR ===Updating Records in a Recital Table using Recital SQL=== * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * ALTER INDEX * CREATE INDEX * TABLE CONSTRAINTS * COLUMN CONSTRAINTS ===Inserting Records into a Recital Table using Recital SQL=== * INSERT ===Selecting Records from a Recital Table Using Recital SQL=== * SELECT * DECLARE CURSOR * OPEN * FETCH * DROP CURSOR ===Updating Records in a Recital Table using Recital SQL=== * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * CREATE INDEX * TABLE CONSTRAINTS * COLUMN CONSTRAINTS ===Inserting Records into a Recital Table using Recital SQL=== * INSERT ===Selecting Records from a Recital Table Using Recital SQL=== * SELECT * DECLARE CURSOR * OPEN * FETCH * DROP CURSOR ===Updating Records in a Recital Table using Recital SQL=== * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * TABLE CONSTRAINTS * COLUMN CONSTRAINTS ===Inserting Records into a Recital Table using Recital SQL=== * INSERT ===Selecting Records from a Recital Table Using Recital SQL=== * SELECT * DECLARE CURSOR * OPEN * FETCH * DROP CURSOR ===Updating Records in a Recital Table using Recital SQL=== * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * COLUMN CONSTRAINTS ===Inserting Records into a Recital Table using Recital SQL=== * INSERT ===Selecting Records from a Recital Table Using Recital SQL=== * SELECT * DECLARE CURSOR * OPEN * FETCH * DROP CURSOR ===Updating Records in a Recital Table using Recital SQL=== * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * INSERT ===Selecting Records from a Recital Table Using Recital SQL=== * SELECT * DECLARE CURSOR * OPEN * FETCH * DROP CURSOR ===Updating Records in a Recital Table using Recital SQL=== * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SELECT * DECLARE CURSOR * OPEN * FETCH * DROP CURSOR ===Updating Records in a Recital Table using Recital SQL=== * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * DECLARE CURSOR * OPEN * FETCH * DROP CURSOR ===Updating Records in a Recital Table using Recital SQL=== * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * OPEN * FETCH * DROP CURSOR ===Updating Records in a Recital Table using Recital SQL=== * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * FETCH * DROP CURSOR ===Updating Records in a Recital Table using Recital SQL=== * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * DROP CURSOR ===Updating Records in a Recital Table using Recital SQL=== * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * UPDATE * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * BEGIN...END TRANSACTION * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * COMMIT * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * ROLLBACK ===Deleting Records in a Recital Table using Recital SQL=== * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * DELETE ===Obtain Information about a Recital Table using SQL=== * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SYSBESTROWIDENTIFIER Description of a table’s optimal set of columns that uniquely identifies a row * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SYSCOLUMNCONSTRAINTS Description of the constraints for a table’s columns * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SYSCOLUMNPRIVILEGES Description of the access rights for a table’s columns * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SYSCOLUMNS Description of the table columns available in the catalog * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SYSCROSSREFERENCE Description of how one table imports the keys of another table * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SYSEXPORTEDKEYS Description of the foreign key columns that reference the primary key columns * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SYSIMPORTEDKEYS Description of the primary key columns that are referenced by the foreign key * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SYSINDEXINFO Description of a table’s indices and statistics * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SYSPRIMARYKEYS Description of the primary key columns in the table * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SYSTABLECONSTRAINTS Description of the constraints for each table available in the catalog * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SYSTABLEPRIVILEGES Description of the access rights for each table available in the catalog * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SYSTABLES Description of the tables available in the catalog * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SYSTABLETYPES Table types available in the database system * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SYSVERSIONCOLUMNS Description of the columns in a table that are automatically updated when any row is updated ===Executing Procedures and Prepared Statements using Recital SQL=== * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * CREATE PROCEDURE * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * DROP PROCEDURE * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * EXECUTE * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * EXECUTE IMMEDIATE * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * PREPARE * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary= * SYSRESULTSET Used to return the singleton result from any Recital expression ===Summary===
