Configuring Schema

The schema for XML fields is configured for an existing TBS Query.

Follow the steps to configure schema:

Configure tbs_info table

1. Execute standard query CONFIG_TBS_INFO under administrative privilege in Table Browser.
2. Get into Insert-Mode by clicking on Insert Mode button and set the appropriate values for Info_Id and Description.
3. Insert the XML schema data for the XML field Value.
4. Add more schema(s) as required by clicking on Add Record button.
5. Click on Commit to finally insert the schema entries into tbs_info table.

Configure tbs_query_info_mapping table

This step is configured only when the XML field data is to be edited in TBS Browser.

1. Execute standard query CONFIG_TBS_INFO_MAPPING under administrative privilege in Table Browser.
2. Get into Insert-Mode by clicking on Insert Mode and set the values as shown below:
   1. QueryName - The TBS Query name for which the schema needs to be defined
   2. Info_Usage - A constant value EDIT_XML_DATA
   3. Info_Type - A constant value SCHEMA
   4. Info_Id - The Info_Id for the schema which is configured in the table tbs_info
   5. ColumnName - The XML column name for which the schema is configured
   6. FileName - The schema file name through which the schema will be referred in the XML field data, for ex. sample.xsd
   7. Description - An appropriate description for this mapping

See also

Edit XML data for details on how the XML field data with schema is edited in Table Browser.