Trigger Types | Description |
---|---|
BEFORE trigger | Trigger is activated before any |
DB2 Development Center
The DB2 Development Center is a graphical tool for developers and database administrators to use in creating and building UDFs and stored procedures. A comprehensive discussion of how to use the Development Center can be found in Appendix A, Development Center. In this chapter, we will use
Transaction information is kept in a set of files that DB2 maintains called the transaction log. Whenever changes occur in a database, information is recorded in the log files so that DB2 can undo the changes if necessary. The
Retrieving Data from the Database
Data is retrieved from the tables through SQL queries. SQL is a very powerful language, and entire books have been written about it. We will not attempt to teach you SQL but rather will introduce its basic concepts. An SQL query can be broken into three major sections:
Late Night Convenience Store Requirements
The Late Night Convenience Store is a successful business that has many loyal customers. In the past, it sold only a limited variety of products, and that made managing inventory very simple. However, business has been growing and customers are starting to demand a larger selection of goods, making inventory control signficantly more difficult. Also, the current method of handling all cash in a shoebox is starting to become a concern because although the store has only one checkout counter now, the owner wants to have additional checkout counters to handle the increased customer volume. A traditional cash register may help in the short term, but the owner has a greater vision.
Subscribe to:
Posts (Atom)