EncartaLabs

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

( Duration: 3 Days )

In IBM i - Database Coding & Implementation Using DDS training course, attendees 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.

By attending IBM i - Database Coding & Implementation Using DDS workshop, attendees will learn to:

  • 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

  • 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

The IBM i - Database Coding & Implementation Using DDS class is ideal for:

  • Individuals who create and maintain a DB2 UDB for i database.

COURSE AGENDA

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

Creating physical files

9

Creating logical files

10

Database performance considerations for application design

11

Database maintenance

12

DB2 UDB for i referential integrity

13

DB2 UDB for i triggers

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top