I just got back from the IBM IOD conference in Las Vegas; it was a great show. Every year there is usually some buzz about what is “hot” with DB2. This year’s buzz was heard loud and clear – XML was being discussed just about everywhere. This is definitely the driving focus for the latest release of DB2 running on both LUW and z/OS. Toad® for DB2 3.0 has many XML features already enabled. You can create tables with XML data types, create indexes on XML columns, import XML data into tables, and generate data reports including XML data. The following is a quick example showing how TOAD will allow you to create a table featuring XML data.
Select the CREATE option from the tool bar and select TABLE:
From the general tab assign a name for the table. Then select the column option to begin adding your columns.
The column data types are release sensitive. When you create a table on V9 LUW the object types will include XML. Create a column with the XML datatype.
The SQL script option will allow you to review the DDL then execute the DDL to generate the table.
To populate the table you can then use the SQL Editor to code inserts or use the IMPORT wizard to import data in a file. You can then also run your XQUERY statements through the SQL EDITOR to query your table as well.
Toad for DB2 is well enabled today to help you build your XML applications.