Complete mode for returning valid XML input documents

You can use Complete mode to create a valid XML input document for the common SQL API stored procedures. Then, you can customize the XML input document and pass it back to the procedure.

If the Complete key is included and you set the value to true, the stored procedure will run in Complete mode, and all other entries in the XML input document will be ignored. The following example shows the minimal XML input document that is required for the stored procedure to run in Complete mode:

<?xml version="1.0" encoding="UTF-8"?>
<plist version="1.0">
<dict>
   <key>Complete</key><true/>
</dict>
</plist>

If the stored procedure runs in Complete mode, a complete input document is returned by the xml_output parameter of the stored procedure. The returned XML document is a full XML input document that includes a Document Type and sections for all possible required and optional parameters. The returned XML input document also includes entries for Display Name, Hint, and the Document Locale. Although these entries are not required (and will be ignored) in the XML input document, they are usually needed when rendering the document in a client application.

All entries in the returned XML input document can be rendered and changed in ways that are independent of the operating system or data server. Subsequently, the modified XML input document can be passed in the xml_input parameter in a new call to the same stored procedure. This enables you to programmatically create valid xml_input documents.