MVS TRAINING, Inc. z/OS, Assembler, COBOL, JCL, REXX, ISPF, CICS, DB2, ISPF/JCL

Back to Database

DB2 UDB for z/OS and OS/390 Advanced Application Programming
4 Days

Participants learn how code advanced SQL such as complex SQL, statements, referencing, inner and outer joins, complex subqueries, table expressions, and advanced SCALAR and columnar functions. AUDIENCE is people in Application Programming who have experience SQL and COBOL.

SESSION CONTENT

Complex SQL entries and performance implications with Joins and Subselects

Correlated Subselects

Using several examples and workshops

Including ANY, ALL, EXISTS

Table Qualifications using several examples and workshops

JOINS using several examples and workshops

INNER

FULL OUTER

LEFT OUTER

RIGHT OUTER

UNION (all types) using several examples and workshops

UNION, UNION ALL

Arithmetic with Date, Time, Null

CASE Statements

New DATE, TIME, SCALAR Functions

Indexing Strategies and schemes

Clustered vs. Non Clustered

KEYS

When to use – Performance issues

Using several examples and workshops

Our DB2 experts can cover any and all topics on this subject—topics can be added or deleted per Client’s needs.

Prerequisites: Participants must have a working knowledge of:

SQL including Select, Insert, Update and Delete

DB2I (SPUFI) - will be used for the purpose of example and workshops

COBOL\DB2 Application Program Coding, Compiling and Binding

WORKSTATIONS AND MAINFRAME ACCESS ARE NEEDED FOR THIS SESSION