O'Reilly logo

SQL for eServer i5 and iSeries by Kevin Forsythe

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6. Creating Database Objects

Up to this point in the book we’ve discussed running various SQL statements in detail. What we haven’t discussed is how to create the table or file objects being used by the SQL statements. Most existing applications use databases that were created using Data Definition Specifications (DDS), Create Physical File (CRTPF), and Create Logical File (CRTLF) commands. Once you are comfortable enough with SQL to use it as your primary database language, you can begin using the data definition commands within SQL to build tables and views. This chapter is devoted to exploring the options and issues involved in creating tables and views.

Schemas, Collections, Libraries, and Databases

Non-iSeries systems often allow for ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required