L’offre de formation

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

Information

Prix 2 375 € HT
Durée : 3 Jours
Ref : OL62G
Type de Formation Click on a delivery method to see details :

Dates de sessions

Voir les sessions pour d'autres pays
Date Localisation
  • Virtual Classroom
    2 375 € HT
  • Paris
    2 375 € HT
  • Paris
    2 375 € HT
  • Virtual Classroom
    2 375 € HT
Cette formation est également disponible en formule intraentreprise ; n'hésitez pas à nous consulter pour en savoir plus.

Description

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.

Objectifs


  • Code the DDS and create the physical and logical files necessary to implement a DB2 UDB for i relational database

  • Describe the advantages of a field reference file, code the necessary DDS and create a field reference file

  • Explain how the choices made while coding the DDS and creating the file affect the performance of the system and the programs using the files

  • Describe the considerations for using the DB2 UDB for i referential integrity and triggers

Public

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

Pré-requis

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

Programme

  • The relational database model
  • Creating physical files
  • Creating logical files
  • Database performance considerations for application design
  • Database maintenance
  • DB2 UDB for i referential integrity
  • DB2 UDB for i triggers
  • The relational database model
  • Creating physical files
  • Creating logical files
  • Database performance considerations for application design
  • Database maintenance
  • DB2 UDB for i referential integrity
  • DB2 UDB for i triggers

Options

La mise en oeuvre et l\'exploitation de SQL/400, les procédures cataloguées, ainsi que l\'ensemble des fonctionnalités de DB2 UDB sont traitées dans le cours OL38FR.

Déroulé

Cours magistral dont 40 % du temps consacré aux travaux pratiques.

© 2021 IRIDIS - Arrow ECS. All rights reserved.