The employee table identifies every employee by an employee number and lists basic personnel information. The employee table is created with the following CREATE TABLE and ALTER TABLE statements:

The sample employee table identifies all employees by an employee number and lists basic personnel information. Employee photo and resume table (DSN8C10.EMP_PHOTO_RESUME) The sample employee photo and resume table complements the employee table.

This group of tables includes information that describes employees, departments, projects, and activities. This information forms a sample application that demonstrates some of the features of SQL. All examples assume that the tables are in a schema named CORPDATA (for …

If you want to run the sample programs against a Host server such as Db2 for z/OS® or Db2 for IBM® i, you need to create a database that contains the sample tables described in the SQL Reference. Cataloging the SAMPLE database

You can create tables and other database objects interactively by issuing SQL statements from SPUFI. In this lesson, you will create a new table that has the same format and contains the same data as the sample EMP table that you queried in the previous lesson.

This topic shows how to create the department and employee work tables and how to fill a work table with the contents of another table: Each of these topics assumes that you logged on by using your own authorization ID. The authorization ID …

These sample tables are referred to and used in the SQL programming and the SQL reference topic collections. Along with the tables are the SQL statements for creating the tables. As a group, the tables include information that describes employees, departments, projects, and activities.

These examples show the SQL statements that you can include in a program to define and work with a serial and a scrollable cursor. Suppose that your program examines data about people in department D11.

this example program is written in the pl/i programming language. xxxxst1 vxrxmx yymmdd create sql pl/i program pliex 08/06/07 12:53:36 page 5 cross reference data names define reference actno 74 small integer precision(4,0) column (not null) in corpdata.empprojact birthdate 74 date(10) column in corpdata.employee bonus 74 decimal(9,2) column in corpdata.employee comm **** column 52 76 comm 74 ...

Example 1: Select all columns and rows from the EMPLOYEE table. SELECT * FROM EMPLOYEE; Example 2: Select the project name (PROJNAME), start date (PRSTDATE), and end date (PRENDATE) from the PROJECT table. Order the result table by the end date with the most recent dates appearing first.