| XSL editor
The XSL editor is a tool for creating, viewing, and validating XSL files.
The XSL editor simplifies development tasks in the following ways:
Provides a wizard that makes it quick and easy to create XSL files and associate them with XML files
Provides numerous wizards, as well as content assist, that make it easy for you to edit your XSL file.
XSL debugging and transformation tool
The XSL debugging and transformation tool can be used to apply XSL files to XML files and transform them into new XML, HTML or text files. As you trace through the transformation, you can use the XSL Debug perspective to debug your source files.
The XSL debugging and transformation tool simplifies development tasks in the following ways:
Provides a simple pop-up menu option for quick transformations as well as a wizard for more complex transformations.
Opens your source files in the XSL Debug perspective after you have run your transformation, enabling you to step through them and see any breakpoints or errors in them, and well as which templates are being called during the transformation.
XML to XML mapping editor
The XML to XML mapping editor maps one or more source XML documents to a single target XML document. You can provide a source file (DTD or XML) and a target file and define the mappings between the source and the target. Each mapping is a selection of a target field, a conversion function and source fields. Mappings can be edited, deleted or stored for later use.
The XML to XML mapping editor simplifies development tasks in the following ways:
Provides a visual interface to easily define mappings between source and target XML documents.
Automatically generates XSLT scripts.
XML and SQL query
You can use the XML and SQL query wizard to create an XML file from the results of an SQL query. You can optionally choose to create an XML schema or DTD file that describes the structure that the XML file has for use in other applications. You can also use the XML and SQL Query wizard to create a DADX file that can be used with the Web services tool. The generated DADX file will contain your SQL query.
Relational database (RDB) to XML mapping editor
The RDB to XML mapping editor makes it easy to define the mapping between relational tables and a DTD file. You can map columns in one or more relational tables to elements and attributes in an XML document. You can generate a document access definition (DAD) script, used by IBM DB2 Extender, to either compose XML documents from existing DB2 data, or decompose XML documents into DB2 data. You can also create a test harness to test the generated DAD file.
The RDB to XML mapping editor is designed to work in conjunction with the DB2 XML Extender. It simplifies development tasks in the following ways:
Provides a visual interface to easily define mappings between relational data and XML elements and attributes.
Automatically generates DAD files.
Automatically generates a test harness.
For more information about XML tools, refer to the online help. There are also samples to help you get started.
Relational database tools
WebSphere Studio provides you will relational database tools that you need to work with relational databases in your application development. The relational database tools include views, wizards, editors, and other features that make it easy for you to develop and test the database elements of your application. Unless explicitly stated, the feature in the relational database tools support all database vendors.
You can manage the database definitions and connections that you need for your application development. You can connect to databases and import database definitions, or you can define new databases, schemas, tables, and views.
You can connect to or import from several database types, such as DB2(R), Oracle, SQL Server, Sybase, Cloudscape, and Informix.
The SQL query builder provides a visual interface for creating and executing SQL statements. You can create a simple statement or add complex expressions and grouping. When you are satisfied with your statement, you can use the SQL to XML wizard to generate an XML document as well as XSL, DTD, XSD, and HTML files, plus other related artifacts, then use the files to implement your query in other applications, for example, a servlet or JSP.
You can create a simple query using the SQL statement wizard, or you can use the SQL query builder that supports a wider range of statements. There is also an SQL editor with highlighting and content assist that allows you to manually edit and create .sql files.
The DB2 stored procedure and UDF builder component provides wizards and tools for creating and working with stored procedures and user-defined functions (UDFs) for use with DB2 Universal Database. When you create an application that accesses DB2 data, you can improve your application's performance by incorporating stored procedures and UDFs that are registered with the database server. You can reduce network traffic and make better use of shared business logic.
After you create a routine (stored procedure or UDF) with one of the wizards, you can modify it in the text editor. When you are satisfied, you can build it and register it on the DB2 server. After the routine is on the server, you can execute it and run the SQL statements that are included in the routine. When you run a routine, you can look in the Output view to see relevant information such as messages, parameters (input and output), and result sets that are returned. If you are not satisfied with the results, you can continue to modify and rebuild the routine until it returns the desired results.
Use this component to create the following types of routines:
SQL and Java stored procedures
SQL UDFs
UDFs that read or receive messages from MQSeries message queues
You can:
Create a new routine using a wizard
Modify existing routines using the text editor
Build (register) routines on the DB2 database server
Run (execute) routines on the DB2 database server
View result sets, messages, and parameters in the Output view
Drop routines from the database
For more information about relational database tools, refer to the online help.
Component test tools
The component test tools provide a framework for defining and executing testcases. The basic framework supports three sorts of testcase: manual, Java, and HTTP. You can also create report generators to work with the data returned by an executed testcase.
You can use the component test tools to do the following tasks:
Define manual testcases, which automate a tester's to-do list
Define HTTP testcases, which automate of requests against a Web site
Define Java testcases, which implement the JUnit framework to automate Java method calls
Run testcases locally or remotely, using the Agent Controller
Track execution results as the testcase executes
Generate reports on your testcase information
Define new report generators
The tools can be used by developers to test their own code, or by testers to coordinate project-wide testing efforts.
For more information about component test tools, refer to the online help.
Testing and publishing tools
The testing and publishing tools (referred to in this section as "Server Tools") provides a unit test environment where you can test JSP files, servlets, and HTML files. It also provides the capability to configure other local or remote servers for integrated testing and debugging of Web and EJB applications. Server Tools supports the following projects: |