Skip to main content
Add Me To Your Mailing List

Welcome to IMUG !

Become part of an organization that supports and promotes your professional success. With an emphasis on technical and management education for IBM Power Systems and predecessor systems (AS/400, iSeries, System i5, etc.) IMUG sessions and seminars also cover general topics such as Security and Disaster Planning. / To join IMUG, click on the "Member Signup" link to the left. / To receive monthly email newsletters without joining IMUG, click "Add Me To Your Mailing List" in the top left corner of the site. / To register for Monthly meetings, click "Events and Meetings" in the left hand column then select the month from the calendar.


System i – DDL vs DDS


In today’s world using SQL / DDL is the obvious path to managing our database objects. This has long been true with the other Database Management Systems and is the future path for the System i. There are major differences in the way DDL objects are treated by the OS resulting in improvements in data integrity and performance. Let’s get a better understanding of why this is the path we should take and how to get there.


SQL Terminology

In the DDS world on System i the terminology used is a bit different from the terminology used in the RDMS world of SQL.  We'll do a short overview. 

What is SQL / DDL ?

A discussion about SQL origins as well as what the functionality of DDL is. 

What are the Advantages of using SQL/DDL ?

The Primary Advantages of using DDL instead of DDS

Data Integrity – Data Validation Differences

Data Integrity – Referential Integrity

Performance – Access Path Performance


SQL / DDL Language Basics

Most common DDL statement examples

DB2 Sequence Objects

How to build / Execute DDL scripts

i Series Navigator

using PDM


DDS to DDL Conversion

i Series Navigator

Using API’s within PDM


Good Practices




Presented by : Chuck Walker


A member of the IMUG board, Chuck has over 25 years experience in IT development and support.  Chuck has considerable experience doing multi-platform design and development -- interfacing System i applications with Visual Basic, Foxpro, SQL Server, MS Office, Web applications and Java as well as SQL and RDBMS development.

Next IMUG meeting:
October 20th, 2015



 Select "Events and Meetings" in left menu for more details.  

IMUG membership entitles you to:

--Networking and Support with Industry Leaders
--Full Access to iMUG website
--COMMON membership and discounts
--Superior Professional Development
--Contact with Vendors specializing in IBM Midrange Computing 





Corporate Memberships $ 120.00 
    Includes all interested employees of member
or wholly owned subsidiaries


Individual Membership:  $65.00 

 Regular Meetings are held the 3rd Tuesday of each month as follows:

Sept thru May:

Meetings are held at 5:30 pm at the
Holiday Inn Vanderbilt 
2613 West End Ave, Nashville, TN 37203


Registration/Meet & Greet: 5:30 - 6:00pm
Dinner: 6:00pm
Presentation: 6:45 - 8:00pm 

($20.00 members / $25.00 non-members)

(+ $5.00 for late registrations)



As IMUG members you are entitled to COMMON Membership through iMUG's affiliation with COMMON.

If you are an IMUG member and wish to request a Common UserID,
please email .  



  Special Program Assistance Provided by: