Sample XML tables

These sample tables can be used for working with XML concepts.

A stored procedure is included as part of the system that contains the data definition language (DDL) statements to create all of these tables and the INSERT statements to populate them. The procedure creates the schema specified on the call to the procedure. Because this is an external stored procedure, it can be called from any SQL interface, including interactive SQL and IBM i Access Client Solutions (ACS). To call the procedure where SAMPLEXML is the schema that you want to create, issue the following statement:

CALL QSYS.CREATE_XML_SAMPLE ('SAMPLEXML')

The schema name must be specified in uppercase. The schema will be created if it does not already exist. Make sure your job's CCSID is set to something other than 65535 before calling the procedure or it will get errors.

Note: In the sample table data descriptions, a question mark (?) indicates a null value.