This course introduces you to application development on an IBM i system. The course begins by identifying and describing the programming languages that are commonly used to develop applications in the IBM i environment, followed by a more detailed look at CL programs. Next, the course describes the ILE program development process.
The course then provides an overview of DB2 for i, the database management system that is on every IBM i system. Next is a discussion on the differences between external data and program described data. The course ends by describing how to create a database file using both SQL and DDS, and how to perform a database query using the SQL SELECT statement.
Approximate Study Time: 3 hours
After completing this course, you should be able to:
- Identify and describe the programming languages that are commonly used for application development in the IBM i environment
- Describe how a program written in a particular programming language is invoked
- List the advantages of packaging CL commands into a CL program
- Identify the CL statements that are commonly used in a CL program
- List the advantages offered by the ILE program development process
- Describe the difference between the original program model (OPM) development process and the integrated language environment (ILE) development process
- List the steps required to create an executable ILE program
- Describe the structure of an ILE program
- Identify the types of objects that can be used as input to a bind operation
- List the steps the binder performs in resolving the symbols referenced by a module
- Identify the advantages database management systems offer over a traditional file system
- Describe the structure of a relational database and use relational database terminology
- Describe the DB2 implementation of a relational database
- Define and use the terms related to distributed database processing
- Describe the processing capabilities in a distributed database environment
- Identify the function and capabilities of a trigger program
- Use and define referential integrity terminology
- Describe the difference between external data and program described data.
- Describe the characteristics of a table, given the SQL CREATE TABLE statement used to define it
- Describe the characteristics of a physical file, given the DDS source statements used to define it
- Describe the general structure of the SQL SELECT statement
- Name and describe the most commonly used SELECT statement clauses
- Describe the results of a query, given an SQL SELECT statement
Introduction to ILE
DB2 for i
Defining a Database
This course is intended for application developers and programmers who are new to the IBM i environment. However, it can be taken by anyone interested in learning about application development in the IBM i environment.
This course assumes that you have a basic knowledge of IBM i facilities. You can satisfy this prerequisite by successfully completing the Manta series Introduction to the IBM i Environment.You may also have obtained these skills by taking other courses or through relevant work experience.