WebSphere Studio Application Developer part 20 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 | Create the schema and tables Select the file and Run on Database Server. The Run Script dialog opens Figure 6-26 . Select the statements that you want to execute. Figure 6-26 Run DDL script Click Next. On the next page set the commit option for example Commit changes only upon success Figure 6-27 . Figure 6-27 Commit options for DDL script Click Next. On the connection page create a connection to the ITSOTEST database. The dialog is the same as Figure 6-5 on page 146. 164 WebSphere Studio Application Developer Version 5 Programming Guide Click Finish and the DDL statements are executed against the database. Using a DB2 Command Window you can verify that the objects are created db2 connect to itsotest db2 select from db2 select from This completes our look at creating database objects. Creating SQL statements There are two alternative ways of creating an SQL statement in Application Developer SQL Statement Wizard The SQL Statement Wizard is a guided dialog through a number of panels with an SQL statement as the result. SQL Query Builder The SQL Query Builder is an editor for an advanced user. Both tools can be used to build an SQL statement. After using the SQL Statement Wizard you can use the SQL Query Builder to updates the SQL statement. For our example we are developing a SELECT statement against the sample EJBBANK database. We would like to see a list of all credit transactions where the last name of the customer contains the letter o . We like to see the transaction ID account ID and the first and last name of the customer as well as the transaction amount. Basically we construct this SQL statement SELECT FROM CUSTOMER c CUSTACCT a TRANSRECORD t WHERE AND AND C AND LIKE lastname Using the SQL Statement Wizard In this section we create an SQL statement using the wizard. To create some order in the .
