DB2 for AS/400 is dead – long live DB2 for IBM i

IBM DB2

DB2/400 and DB2 UDB for iSeries are essentially the same thing. iSeries(AS/400) was able to adopt the IBM DB2 UDB branding when it delivered a lot of new database functionality in V4R4 of OS/400, so the database was renamed fromDB2/400 to DB2 UDB for iSeries in that release.

Get up to date with triggers and referential constraints in DB2. They will be at the core of new development, especially if the database is going to be accessed from other platforms or from the Web. But to discover some of the newer features (column constraints, user-defined functions, etc.), you will have to become familiar with SQL.

You can create a table from the result of a SELECT statement. To create this type of table, use the CREATE TABLE AS statement. All of the expressions that can be used in a SELECT statement can be used in a CREATE TABLE AS statement. You can also include all of the data from the table or tables that you are selecting from.

For example, create a table named EMPLOYEE3 that includes all of the column definitions from EMPLOYEE where the DEPTNO = D11.

CREATE TABLE EMPLOYEE3 AS
 (SELECT PROJNO, PROJNAME, DEPTNO
 FROM EMPLOYEE
 WHERE DEPTNO = 'D11') WITH NO DATA

If the specified table or view contains an identity column, you must specify the option INCLUDING IDENTITY on the CREATE TABLE statement if you want the identity column to exist in the new table. The default behavior for CREATE TABLE is EXCLUDING IDENTITY. There are similar options to include the default value, the hidden attribute, and the row change timestamp attribute. The WITH NO DATA clause indicates that the column definitions are to be copied without the data. If you want to include the data in the new table EMPLOYEE3, include the WITH DATA clause. If the specified query includes a non-SQL-created physical file or logical file, any non-SQL result attributes are removed.