| Trigger Types | Description |
|---|---|
| BEFORE trigger | Trigger is activated before any |
Thursday, 18 March 2010
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:
Tuesday, 16 March 2010
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.
DB2 Information Center
No getting-started chapter would be complete without a discussion of where to find more information. For most users, the primary source of official DB2 information will be the DB2 Information Center. Open a
Friday, 12 March 2010
Creating a Database
In subsequent chapters, you will build an application against a database called L8NITE.
From the Control Center, right-click the All Databases folder and select Create > With Automatic Maintenance
Step 1: Specify the database name and location
DB2 Graphical Tools
DB2 Express includes an easy-to-use suite of tools to help you manage your database without having to learn the DB2 command-line environment. Over the course of this book you will see more of the capabilities of these graphical tools. This section gives you an initial look at two of these tools—the DB2 Control Center and the Command Editor—and explains what you can do with them.
Installing DB2 Express
A time limited trial edition of DB2 Express v8.2 can be downloaded from the IBM Web site at http://www.ibm.com/software/data/db2/udb/db2express/. A unlimited evaluation version of DB2 Express (and license) is available by registering at the IBM Virtual Innovation Center:
What's Cool about DB2 Express v8.2
You may have heard about IBM's new major initiative called "on demand." A significant part of this strategy is autonomic computing: software and hardware that is self-managing, self-tuning, and self-healing to reduce the cost and complexity of technology.
DB2 v8.2 has industry-leading autonomic tech
What Is DB2 Express?
DB2 Express is a member of the DB2 Universal Database family of products. Other members of the family are as follows:
- DB2 UDB for Linux, UNIX, and Windows
IBM DB2 UDB Express Edition Version 8.2 delivers everything small to medium-sized businesses need to accelerate time-to-value and dramatically reduce TCO in their database applications. Now, IBM's own experts show exactly how to get started with DB2 Express, and use it to develop, deploy, and manage superior applications from start to finish.
Subscribe to:
Posts (Atom)