IBM DB2 manual Shell scripts, Scripts containing DDL and SQL statements

5.6.1 Scripts

Table 5-6lists the scripts used in the examples in this chapter.

Table 5-6 Scripts containing DDL and SQL statements

Script name	Description
itsodb.ddl	Contain DDL and SQL statements to create the database layout and
	database object for our sample database ITSODB.
itsodb2.ddl	Contain DDL and SQL statements to create the database layout and
	database objects for the modified sample database ITSODB2.
export.sql	Contain statements to export data from either the DB2 sample
	database or the ITSODB sample database. Data are exported using
	the IXF file format. The tables exported are STAFF, EMPLOYEE
	and DEPARTMENT.
import.sql	Contain statements to populate data to tables STAFF, EMPLOYEE,
	and DEPARTMENT using the DB2 import utility.
load.sql	Contain statements to populate data to tables STAFF, EMPLOYEE.
	and DEPARTMENT using the DB2 load utility.
alteritso.sql	Contain statements to migrate the database objects from ITSODB
	to ITSODB2.
department.sql	Contain SQL INSERT statements to populate the DEPARTMENT
	table.
employee.sql	Contain SQL INSERT statements to populate the EMPLOYEE
	table.
staff.sql	Contain SQL INSERT statements to populate the STAFF table.
populate.sql	Contain SQL INSERT statements to populate all three tables.

5.6.2 Shell scripts

We divide the scripts into supportive shell scripts and plain shell scripts. Supportive scripts are used to execute the plain scripts when we want to act on the return code from the executed plain script. Table 5-7lists the supportive shell scripts. The plain scripts are listed in Table 5-8.

When we refer to the execution environment, we mean the command shell from where we invoke the shell script.

252DB2 Deployment Guide