OL37: Accessing the IBM i Database Using SQL
DURATION: 2 days
SCHEDULED DATES: TBD – Contact Us for more Information
PURPOSE
SQL is a very powerful programming and database language that is widely used in business today. For example, SQL can be used to perform interactive database queries as well as extract data from a server and pass that data to a Java applet running on a client PC. SQL is frequently used in IBM i system, high-level languages as an alternate means to access the database.
This course is designed to teach IBM i programmers and highly-skilled IBM i system users how to access the database using SQL. Students learn how to create, maintain, and query the database using the interactive SQL interface and System i Navigator.
AUDIENCE
This course is designed primarily for experienced IBM i programmers. However, skilled IBM i system users who want to learn how to use the SQL programming language as a means to access the DB2 for IBM i database might also consider attending this class.
This course is not recommended for users who need to perform simple queries. Query for IBM i is an user-oriented tool designed for simple queries.
PREREQUISITES
Before attending this class, the student should be able to:
• Use a Windows-based PC
• Navigate and use a Windows-based desktop
• Use basic IBM i navigation tools, including:
– CL commands
– Online Help
– WRKSPLF and related commands to manage output
– WRKJOB, DSPMSG, DSPJOB commands and so forth to perform basic problem determination
• Use the Program Development Manager/Source Entry Utility or the RSE LPEX Editor to create and maintain source files
• List and explain the use of data types supported by the DB2 for i database
These skills can be gained by attending OL49/OL490 – IBM i Application Programming Facilities Workshop.zation would be beneficial.
OBJECTIVES
After attending this class, the student should be able to:
• Use Data Definition Language (DDL) to describe tables and views
• Use UPDATE, INSERT, ALTER, and DELETE to modify SQL tables and maintain a database
• Use the SELECT statement to extract data from tables and views
• Code SQL queries that include column and scalar functions
• Code SQL queries that include inner and outer joins
• Use SQL Query Manager
CONTENT
Course units:
1. SQL concepts
2. Extracting data using SELECT
3. Functions
4. JOIN and UNION
5. SubSELECTs
6. Query tools
7. Database maintenance
