Last generated: Wed Nov 17 12:50:36 2004 EST.
- Trigger example script in DB2 notation.
- Download the following two SQL scripts into your UNIX account:
company_schema.sql (script to create example schema) and company_data.sql (script to populate example data). Open two files using PICO, and change the first line's "dul13" to your PSU ID. Then, run the following:
If you already have any of the following tables in DB2 -- employee, dept,
item, parts, supply, sale, debit, city, store, supplier -- then, you
will get an error. In that case, drop the table first (eg, DROP TABLE
foo), and re-run. At the end, make sure you have all the necessary
schema/data successfully created in DB2 by running:
- Unix prompt% db2 -tf company_schema.sql
- Unix prompt% db2 -tf company_data.sql
- db2 => list
- .cshrc: Download this and store it in your CAC home directory.
- When you send a DB2-related question to ITS at PSU, use firstname.lastname@example.org with a copy to TA or instructor.
- How to use SSH client to connect DB2 at CAC Unix machines
- How to create tables and add values in DB2
- How to run SQL commands stored in a file in DB2
- Full DB2 Documentation
- DB2 SQL Commands HELP
- SSH Shell download