O'Reilly logo

The Programmer’s Guide to iSeries Navigator by Paul Touhy

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

Tables

Tables are the base building blocks for a database. Select New → Table from the context menu of Tables to see the window shown in Figure 4.4. The window has tabs for Table, Columns, Key Constraints, Foreign Key Constraints, Check Constraints and Partitioning. Select Definition from the context menu for a table to change its definition.

Figure 4.4. Creating a new table.

Table

You name the table in the Table tab, and it is also where you see one of the first differences between DDS and SQL. DDS is restricted by the normal ten-character restriction on names, but this is not so for SQL: SQL names can be up to 128 characters ...

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