Previous Topic: Obsolete Override PeriodsNext Topic: The Relational Data Framework


Using the Relational Data Framework

This section contains the following topics:

The Relational Data Framework

Why We Chose SQL

Assumptions

The Role of Relational Tables

How the Product Stores Table Data

Tables the Product Provides

Table Restrictions

Reserved Keywords in SQL Statements

Operations Performed With the CA OPS/MVS SQL

What Are the Differences From Standard SQL?

About the Sample Tables

Invoking SQL Statements

Tools for Importing, Exporting, and Backing up Tables

Storing Data in and Requesting Data From Relational Tables

Searched, Cursor, and Table Management Operations

Searched Operations

Use the ORDER BY Clause to Arrange Values

Use the WHERE Clause to Select Values

Use Comparison Predicates in WHERE Clauses

Use IN Predicates in WHERE Clauses

Using LIKE Predicates in WHERE Clauses

Use Expressions and Functions

Join Operations

Using Subqueries

Cursor Operations

Table Management Operations

Use the Relational Table Editor Batch API

Backup and Restore Your RDF Tables