Filter
Top Products
102 The XML Files: Development of XML/XSL Applications Using WebSphere Studio
6.1 The SQL to XML wizards
The SQL to XML wizards are found in the data perpective. To demonstrate the
wizards and the files produced, a schema and SELECT statement has to be
created. The schema is shown below in Figure 6-1. It consists of three tables:
PASSENGER, SCHEDULE, and AIRCRAFT. The PASSENGER and
SCHEDULE tables are joined by the flight and flightNo attributes. The aircraft
attribute on the SCHEDULE table is connected to the aircraft_key attribute on the
AIRCRAFT table through a foreign key.
Figure 6-1 The Passenger List Select statement