WebSphere Studio Application Developer part 19 provides integrated development tools for all e-business development roles, including Web developers, Java developers, business analysts, architects, and enterprise programmers. The customizable, targeted, role-based approach of WebSphere Studio Application Developer will be characteristic of all new products built on the WebSphere Studio Workbench. It is well integrated with WebSphere Application Server and provides built-in server test environments that can be used for testing and profiling Web applications | simpleType restriction base string length value 3 restriction simpleType element element name FIRSTNAME simpleType restriction base string length value 30 restriction simpleType element element name LASTNAME simpleType restriction base string length value 30 restriction simpleType element element name USERID simpleType restriction base string length value 8 restriction simpleType element element name PASSWORD simpleType restriction base string length value 8 restriction simpleType element element name ADDRESS simpleType restriction base base64Binary length value 2000 restriction simpleType element sequence complexType element schema Notice the Graph page of the XML schema editor Figure 6-14 . Expand the boxes by clicking the icon. 154 WebSphere Studio Application Developer Version 5 Programming Guide B Schema Global Elements CUSTOMER_ type anonymousAtj CUSTOMER_TABLE type anonymous Complex Types Groups Design Source Graph Figure 6-14 XML schema editor graph Study the Outline view as well. It shows the structure of the XML schema file. If you want you can make changes to the XML file and generate a new DDL file by selecting Generate - DDL context . Creating database objects Application Developer provides support for creating new databases new schemas and new tables. Create database To create a new database you have to have a project. If you have not already done so you should now create a new simple project called ItsoProGuideDatabase. To create database objects you have to switch to the Data perspective and open the Data Definition view. Chapter 6. Developing database applications 155 To create a database select the ItsoProGuideDatabase project and New - New database definition. The Database creation dialog is displayed Figure 6-15 . Figure 6-15 Database definition dialog Here you specify the name of the new database and the vendor type. When you later generate the database DDL it will conform to the database type that you select. Click Finish .
