Ibm Data Server DB2 Manual de usuario descargar pdf (Pagina 266)

252 DB2 Deployment Guide

5.6.1 Scripts

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

Table 5-6 Scripts containing DDL and SQL statements

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-7 lists 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.

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.

1 2 ... 261 262 263 264 265 266 267 268 269 270 271 ... 297 298

Sin comentarios

Ibm Data Server DB2 Manual de usuario Pagina 266