Sample tables
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 corporate data).
A stored procedure is included as part of the system that contains the data definition language (DDL) statements to create all of these tables and the INSERT statements to populate them. The procedure creates the schema specified on the call to the procedure. Because this is an external stored procedure, it can be called from any SQL interface, including interactive SQL and IBM® i Access Client Solutions (ACS). To call the procedure where SAMPLE is the schema
that you want to create, issue the following statement:
CALL QSYS.CREATE_SQL_SAMPLE ('SAMPLE')Note: In the sample table data descriptions, a question mark (?) indicates a null value.