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

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.

366 Students

Content

·                      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


Target Audience

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


Duration

3 Days - Basic to Intermediate

L.E 0


Get your team access to 1,000 Jupiter courses anytime, anywhere








llllllllllllllllllllllllllllllll


kkkjgfrrtfygkhlhkk