DB2 for i - DB Coding and Implementation Using DDS and CL Commands - OL62G

Beschreibung

Learn how to code, create and maintain DB2 UDB for i physical and logical files using native Data Description Specifications (DDS) and Control Language (CL) commands. Build a DB2 UDB for i relational database foundation, if you intend to write application programs for the IBM i system, however the course does not address SQL implementation of DB2 UDB for i. Learn many techniques that, if implemented, enhance the performance of applications using the database.

Training Paths that reference this course are:
  • Application Developer using RPG IV
  • error_outline Wichtige Information

    AKTION: Wir garantieren das Stattfinden dieses Seminars bereits ab 3 Teilnehmern!

    expand_more chevron_right Zielgruppe

    This is a basic course for individuals who create and maintain a DB2 UDB for i database.

    expand_more chevron_right Vorkenntnisse

    You must be able to: Use Program Development Manager (PDM) and Source Entry Utility (SEU) to enter source code into a source file Use PDM to create an IBM i object from a source file member Explain the function of DDS in defining files on the i Use Data File Utility (DFU) to maintain a physical file

    expand_more chevron_right Detail-Inhalte

      1. The relational database model
      2. Creating physical files
      3. Creating logical files
      4. Database performance considerations for application design
      5. Database maintenance
      6. DB2 UDB for i referential integrity
      7. DB2 UDB for i triggers
      8. The relational database model
      9. Creating physical files
      10. Creating logical files
      11. Database performance considerations for application design
      12. Database maintenance
      13. DB2 UDB for i referential integrity
      14. DB2 UDB for i triggers
    • expand_more chevron_right event_available 11.01.-13.01.2021 11.01.2021 Seminarzeitentimer3 Tage3 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
      • expand_more chevron_right ETC Live - Virtual Classroom 2,325.00
        • Virtual Training – aber live im Seminar
        • Keine Anfahrt ins Seminarzentrum notwendig
        • Seminarunterlagen, Teamwork, Labs 24/7
        • ETC>Live Support und Hotline
        • ETC-Services

         

      • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,325.00
        • Ihr ILT Seminar (Instructor Led Training)
        • Seminarunterlagen, Teamwork, Labs
        • Verpflegung vorort in einem der ETC Seminarzentren
        • Seminar-Services
    • expand_more chevron_right event_available 05.07.-07.07.2021 05.07.2021 Seminarzeitentimer3 Tage3 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
      • expand_more chevron_right ETC Live - Virtual Classroom 2,325.00
        • Virtual Training – aber live im Seminar
        • Keine Anfahrt ins Seminarzentrum notwendig
        • Seminarunterlagen, Teamwork, Labs 24/7
        • ETC>Live Support und Hotline
        • ETC-Services

         

      • expand_more chevron_right ETC Classroom - im Seminarzentrum 2,325.00
        • Ihr ILT Seminar (Instructor Led Training)
        • Seminarunterlagen, Teamwork, Labs
        • Verpflegung vorort in einem der ETC Seminarzentren
        • Seminar-Services