DB2 for i: DB Coding and Implementation Using DDS and CL Commands
Kurs
In Frankfurt Am Main, Zürich (Schweiz) und Wien (Österreich)
Beschreibung
-
Kursart
Kurs
-
Ort
This is a basic course for individuals who create and maintain a DB2 UDB for i database. Das Zentrum IBM präsentiert das folgende Programm, mit dem Sie Ihre Kompetenzen stärken sowie Ihre gesteckte Ziele erreichen können. In dem Kurs zu dieser Schulung gibt es verschiedene Module zur Auswahl und Sie können mehr über die angebotenen Thematiken erfahren. Einfach anmelden und Zugang zu den folgenden Themen erhalten
Standorte und Zeitplan
Lage
Beginn
Beginn
Beginn
Beginn
Beginn
Hinweise zu diesem Kurs
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
Meinungen
Themen
- DB
Inhalte
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 (DB2, WDSc, RPG, CL, SQL) RPG Path
- Application Developer using RPG IV
Zusätzliche Informationen
- 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
DB2 for i: DB Coding and Implementation Using DDS and CL Commands