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


  •  LINUX UNIX z/OS ON-SITE TRAINING  | IT SERVICES  | CONTACT US  | ISPF JCL REXX BOOKSTORE  | HOME

    Copyright © 2012 MVS TRAINING, INC. All rights reserved
    All trademarks & Copyrights are property of their respective manufacturers.