Creating and Managing Database Objects Using SQL (Online Seminar)

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.

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

Skip Marchesani left IBM after 30 years to pursue a consulting career with Custom Systems Corp. He also helped found System i Developer and the RPG & DB2 Summit. Skip spent much of his IBM career working with the Rochester Development Lab on projects for S/38 and AS/400 and was involved with the development of the AS/400.