SQL/400
Create
a database (SQL collection) using SQL data definition language
statements.
Populate an SQL collection using SQL data manipulation language
statements. Use the
SQL interactive environment to select, sequence, join, and summarize data
from SQL tables and 400 files. Use
SQL queries to extract information about the SQL collection itself. Use
SQL statements to access physical and logical files created outside of the
SQL collection. Use
SQL interfaces within RPG/400 and COBOL/400 programs. Use
SQL calls in interactive HLL programs that dynamically create access
paths to data. Create
reports using Query Management Queries and Forms. Pass
parameters from HLL programs to Query Management Queries. Convert
Query/400 queries to Query Management Queries and Forms.| 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 |
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 |
| Audience iSeries-AS/400 programmers. Prerequisites System Operations Database Administration I Database Administration II Interactive RPG or COBOL programming experience |
Format Self-Instructional Materials Fifteen Audio CDs Student Text Workbook Interactive Media |
Time Required Approximately 16 Hours |