Specifying XML columns

To process XML column data, specify only the tables that contain the XML columns in your filter, not the XML tables or table spaces. (BMC AMI Log Master automatically locates and obtains data from the XML objects.)

Related topic

Specifying-large-volume-column-processing

To specify XML columns

  1. Define XML processing values.The online interface fields are as follows:

    • Run Time Options panel: XML Option field
    • Work ID Run Time Options panel: XML Option field
    • XML Options panel

    The SYSIN syntax keyword is the XMLOPTS statement.

  2. Include XML data in output files.The online interface field is the Include XML field on the following panels. XML column data is not included in output DDL files.

    • SQL Output panel
    • Logical Log Output panel
    • Load Output panel
    • Report Output panel

    The SYSIN syntax keyword is the INCLUDE XML keyword.

Important

For larger XML output records, consider unloading to VBS data sets by using SPANNED YES.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*