Data flow control with XML or JSON

📄️ Data flow control with XML or JSON

Exporting and importing XML or JSON data

📄️ Example: Simple XML or JSON export

Simple XML export

📄️ How import XML or JSON is processed

"UPSERT" default handling

📄️ Obsolete children on import

An obsolete child is a child record that is considered to be no longer relevant if new information about the parent and its children is imported.

📄️ Generating key values for parent-child data on import

If you use XML.Import to import into a table for which the receiving repository normally generates unique primary key values:

📄️ XML import: Known problems and workarounds

This help topic discusses typical problems with XML.Import(). Some of these problems are inherent in the USoft product and require workarounds. Others are mistakes that developers often make in practice.

📄️ Example: XML export with DTD name and IO formats

Here is an example of an XML export with the DTD name and IO Formats:

📄️ Example: XML or JSON export in combination with USFile

Here is an example that writes an XML export to a file opened by USFile:

📄️ Example: Simple XML query

Here is an example of a simple XML query. This XML query executes the query stored in the xmlquery column of the XMLQUERIES table. The SELECT statement may retrieve zero or more records with an XML query document to be executed:

📄️ Example: XML query with Order-by attributes

Here is an example of an XML query document with several Order-by attributes specified:

📄️ XQuery

USoft provides support for native Oracle XQuery function using the RDBMS keyword.