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

102 The XML Files: Development of XML/XSL Applications Using WebSphere Studio

Page 118
Image 118
IBM Version 5 manual SQL to XML wizards, Passenger List Select statement