In his spare time, he enjoys all sorts of sporting activities, including running with his dog Chachi, avoiding punches in his MMA training, and trying to figure out the world according to Chloë - his daughter. Paul is a DB2 Certified Advanced Technical Expert (DRDA and Clusters) and a DB2 Certified Solutions Expert (BI and DBA). Paul has written more than 230 magazine articles and 11 books on DB2 including, Information on Demand: Introduction to DB2 9.5 New Features, DB2 9 Database Administration Certification Guide and Reference (6th Edition), DB2 9: New Features, Information on Demand: Introduction to DB2 9 New Features, Off to the Races with Apache Derby, DB2 Version 8: The Official Guide, DB2: The Complete Reference, DB2 Fundamentals Certification for Dummies, DB2 for Dummies, and A DBA's Guide to Databases on Linux. He is an award-winning writer and speaker with more than 14 years of experience with DB2. Zikopoulos, BA, MBA is the Program Director for the DB2 Evangelist team at IBM. To build an SQL statement from the Database Explorer view,Ī database connection object and select New SQL Statement. This query returns all the female employees in a company. WHERE DEPARTMENT.DEPTNO = EMPLOYEE.WORKDEPT SELECT DEPARTMENT.LOCATION, EMPLOYEE.EMPNO,ĮMPLOYEE.PHONENO FROM DEPARTMENT, EMPLOYEE Let’s look at how to build the following query using You can access this tool from different parts of Rational DA, However, while many buildings have rational qualities, only some can be. Rational DA comes with a built-in tool for creating SQL In architecture, the concept of rationalism refers to a building committed to a logical, mathematically ordered design. View, namely, the ability to build SQL statements to run against your database. In thisĪrticle, I want to show you one of the features available from the Database Explorer Or you didn’t read that article, it would be helpful to review it now. If you’re not familiar with that process, You how to add database connections to it. IBM Rational Database Architect (Rational DA) Database Explorer view and showed Data Architect and DB2 9: The Database Explorer,” I introduced you to the
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |