YOUR IBM i TRAINING SOURCE

You must allow the browser to execute JavaScript programs if you want to view product information. If your browser is set up to execute JavaScript programs, the problem is that the product ID was incorrect. Use the menu bar above to find the desired product.

Skip Marchesani
System i Developer

Overview

Are you aware that IBM stated has stated that all future enhancements to DB2 for IBM i would be made only via the SQL interface and that the native interface (CL, DDS, etc.) would be stabilized? Do you know that almost all of the database enhancements since Versions 4 are available only through the SQL interface? Do you know that you can use SQL to create, manage and manipulate your database objects, or use a combination of both DDS and SQL? If the answer to any of these questions is, 'No', this seminar will show you how SQL can play a role in managing your DB2 database. You will explore the use of several SQL statements including CREATE and DROP to create and delete physical and logical files. You will also learn how to create and save SQL scripts that provide function similar to DDS and CRTPF or CRTLF. And, a combination of both DDS and SQL can be a vital tool.

Approximate Study Time: 90 minutes

Objectives

After completing this seminar, you should be able to:

Describe how SQL can play a role in managing your DB2 for IBM i database
Identify the SQL statements including CREATE and DROP to create and delete tables, views, and indexes (physical and logical files)
Create and save SQL scripts that provide function similar to DDS and CRTPF or CRTLF

Topic Outline

Executing SQL on the i5 and iSeries

Four Types of SQL Statements

Data Definition Statements

Understanding SQL Examples

SQL Statement Examples

Create a Physical File (Table) Using DDS

Create a Table (Physical File) using SQL

Differences Between CRTPF and CREATE TABLE

Resolving the Differences

Can SQL be Saved and Stored Like DDS?

SQL Statement Processor

System i Navigator

Multi-Member Files

Audience

This seminar is intended for system programmers, application programmers, database administrators, and business analysts.

Prerequisites

This seminar is based on the SQL function available in IBM i, assumes you have a basic understanding of relational database concepts and SQL, and assumes you are familiar with using the SELECT, INSERT, UPDATE, and DELETE statements.