SQL Concepts
Using SQL across Multiple Operating Systems
Collections
Tables
Rows and Columns
Views
Indexes
Cursors
Communication Areas
SQL Data Definition Statements
CREATE COLLECTION
CREATE TABLE
CREATE VIEW
CREATE INDEX
Documenting the Data Base Model
|
SQL Data Manipulation Statements
SELECT
INSERT
UPDATE
WHERE
GROUP BY
UNION
SQL Predicates and Functions
Commitment Control
Query Management Queries and Forms
Creating Queries and Forms
Passing HLL Parameters to Queries
Converting Query/400 to QM Queries and Forms |
Interactive SQL/400
STRSQL (Start SQL) Command
Setting and Saving SQL Session Defaults
SQL Entry Screen
Executing SQL Statements
Embedded SQL/400 in High-Level Languages
COBOL and RPG Examples
Accessing SQL Tables and Cursors
Serial and Scrollable Cursors
Updateable Cursors
Dynamic Data Selection
SQL Precompiler
SQL Optimizer
SQL/400 Subqueries
Interactive and Embedded
Simple Subqueries
Compound Subqueries
Correlated Subqueries |
