USoft set processors

USoft processes structured data sets in a set-oriented way, using primarily SQL-based and XML-based techniques.

SQL-based set processors execute SQL written in USoft constructs such as constraints, Logical Views, batch jobs, and SQL statements in other tools such as the Service Framework. A number of relational structures such as Delete Rules for relationships are also implemented using a SQL-based set processor.

XML-based set processors use XSLT to transform an XML data set (presented as an XML document) into a different XML dataset. These processors are RDMI (Rules-Driven Method Invocation) components in USoft, meaning that they can be called from a SQL context. See the USoft Definer Help for full details on RDMI.

Further XML-based components have been added to provide a full XML toolkit, especially the XML.IMPORT and XML.EXPORT methods that allow you to move relational data between repositories and exchange them between a USoft application and other software.

•"Mix in" data sets into the input XML or into the XSLT stylesheet before the XSLT transformation is executed. For details of "mixing in", see the sections on USXSL in USoft Definer Help.

The USXSL internal component is an XSLT 1.0 processor written in Xalan/C++ that allows you to apply XSLT 1.0 transformations to XML data sets.

This component is fully documented in the RDMI section of the USoft Definer Help. It is currently the standard component for executing XSLT 1.0 in a USoft context.

This component supersedes the earlier XSL off-the-shelf component, an XSLT 1.0 processor written in Xalan/Java now supported for backward compatibility only.

The USCSXSL internal component is an XSLT 1.0 processor written in .NET/C# that allows you to apply XSLT 1.0 transformations to XML data sets.

Compared to the USXSL component, this component has the special characteristic of being aware of the functions referenced in the Batch.1.0.xsl stylesheet found in the \xsl\Util subfolder of your USoft installation folder. This makes this component suitable for executing these operations on input XML documents referred to as USoft Blend scripts.

You can invoke this component in the same way as any other RDMI component from a USoft context, but you can also call it from the command line using ublendit.exe.