In fact, since the Rational AD IDE maintains a cache of the DB2 UDB database you are working with, you can even work in a disconnected mode (offline) and still leverage this feature.įor example, consider the SQL that is automatically generated for you after dragging the RADCUSTOMERORDERS and RADCUSTOMERS tables into the Table area of the SQL Builder: The assistance is hooked into the underlying database’s schema – not just the respective programming language semantics. However, when you use the Rational AD IDE to work with a DB2 database, the capabilities extend beyond what IntelliSense offers Visual Studio developers. Perhaps one of the most rapid application development features in the Rational AD IDE that I know of is SQL Assist, which is similar to IntelliSense in Microsoft Visual Studio.
![db2 universal database db2 universal database](https://www.oreilly.com/library/view/db2-universal-database/0738491373/bgab.png)
![db2 universal database db2 universal database](https://images-na.ssl-images-amazon.com/images/I/41M87GTMTTL._SX218_BO1,204,203,200_QL40_ML2_.jpg)
You can see that the SQL Builder automatically flags referential integrity relationships such as primary keys (using the icon) and foreign keys (using the icon) for any tables that you want to work with in the Tables pane. INSERT INTO RADCUSTOMERORDERS VALUES (1, 34544.22, 1),Īfter you have created these tables and inserted the data, the Data Definition view in your Rational AD IDE should look similar to this: INSERT INTO RADCUSTOMER VALUES(1,’BAKLARZ’), (2,’JAMES’),(3,’ZIKOPOULOS’) REFERENCES RADCUSTOMERS ON DELETE NO ACTION) (ORDERID INT NOT NULL PRIMARY KEY, ORDERAMOUNT DEC(8,2),ĬUSTOMERID INT, FOREIGN KEY CUSTOMERIDTOID (CUSTOMERID) (ID INT NOT NULL PRIMARY KEY, NAME VARCHAR(30)) To experience some of these features outlined in this article, run the following data definition language (DDL) statements to create the RADCUSTOMERS and RADCUSTOMERORDERS tables in the NEWSMPL database you created earlier in this series: CREATE TABLE RADCUSTOMERS This section introduces you to various design-time features of the SQL Builder that accelerate the development of SQL statements. Note: The steps in this article assume that you have read the first three parts in this series, and have built the associated schema objects outlined in each of those parts.
#Db2 universal database how to
You are not required to understand how to use these features to build an SQL statement (since I didn’t introduce you to any of them in Part 5), but understanding them will greatly enhance your productivity. What I will show you is very different from creating SQL statements as you did in Part 5. In Part 6 of this series, I focus on some of the SQL Builder features that accelerate application development.
#Db2 universal database series
Part 5 of this series introduced you to how you to build SQL statements using the SQL Builder that is part of the Rational AD IDE.
![db2 universal database db2 universal database](https://i.ebayimg.com/images/g/x-IAAOSwZGBf~aRk/s-l300.jpg)
Part 4 taught you how to use Rational AD to build a simple user-defined function (UDF), as well as a complex UDF that invokes a Web service. Part 3 taught you how to use Rational AD to build a stored procedure, deploy it, and test it. Part 2 introduced you to some of the many capabilities provided by the Data Definition view in the Rational AD integrated development environment (IDE).
#Db2 universal database software
In Part 1 of this series, I discussed how to use the Database Explorer view in the IBM Rational Application Developer for WebSphere Software (Rational AD) product to create and work with IBM DB2 Universal Database (DB2 UDB) for Linux, UNIX, and Windows database connections.