Homework #1 (optional, due: 09/23/08 in class)

CS 348 Waterloo, Fall '08

This homework is set up to ensure that everyone following the class is comfortable with using the installation of DB2 (IBM's Relational Database System) in the UWaterloo UNIX environment.

Answer the following two questions:

  1. what is the meaning of the SQL1024N error?
  2. what tables have been created after batch executing sampleDB.db2 file?
  3. what other errors did DB2 complain about when executing the above file and what is their meaning?
For all the questions provide a relevant printout showing DB2's output that answers the question (you can use, e.g., the tee(1) command in UNIX to capture the output of DB2 to a file).

Fine print: the usual university policies on academic honesty, fair use of computing facilities, etc., apply by default.