XML data type for application programs
Use the Add or Edit Fields wizard to define the XML column that are used by your XML database application programs.
To use IMS™ Universal JDBC driver support for XML, you need to define the XML data type column fields for storing and retrieving XML data.
The XML database supports the following operations:
- Retrieve XML data from an IMS database as a character large object (CLOB) through a SQL SELECT statement.
- Store XML data into an IMS database, through a SQL INSERT statement, by using either the PreparedStatement.setClob method or the PreparedStatement.setCharacterStream method.
There are two types of XML fields you can define using the Add or Edit Fields wizard.
- Decomposed XML field
- Set the start position to 0 and specify the XML schema URL that the XML database uses.
- Intact XML field
- Set the start position and length to a nonzero number, specify the XML schema URL, and specify the Overflow segment name that the XML database uses.
Note: IMS Version 12 and
later supports new DBD generation parameters for XML data type definitions.
If you use these parameters, the Java™ metadata
class already contains the XML definitions and you do not need to
modify the class. If you are using the IMS catalog
database, the metadata is available with a data connection instead
of with a static metadata class.