|
Home > Online Product Documentation > Table of Contents > Calling Number Functions Calling Number FunctionsThis section describes the number functions that you can call in a query. The operations you can perform are Converting an Object to a Number
In some situations, you might want to force a numeric comparison. The XPath processor performs a numeric comparison if either operand is numeric and neither is Boolean. (If one operand is Boolean, the XPath processor converts the other to Boolean and performs a Boolean comparison.) However, if neither operand is a numeric or Boolean value, you can call the
To perform a numeric comparison, you must call the
The format of the
If you omit the argument, the value of the argument defaults to a node set with the context node as its only member.
Table 85 shows how the
Obtaining the Sum of the Values in a Node Set
To obtain the sum of the values of the nodes in a set, call the
For each node in the argument node-set, the XPath processor converts the string value of the node to a number. The
Obtaining the Largest, Smallest, or Closest Number
To obtain the largest integer that is not greater than a particular number, call the
The
To obtain the smallest integer that is not less than a particular number, call the
The
To obtain the closest integer to a particular number, call the
The
|
Converting Custom EDI Message Types to XML
Vital and valuable legacy data locked in proprietary EDI files? See how to use DataDirect XML Converters™ custom EDI message type tools to convert nonconformant EDI to XML.
Introduction to Convert to XML
Convert to XML is Stylus Studio's all-purpose utility for getting legacy data integration of all sorts into a custom XML format. This video provides an overview of the tool and walks you through a sample CSV to XML data transformation project.
Generate XML Schema
Generate XML Schema data models from one or more XML instance documents, or by converting other data models (DTD's, Relational Schemas, EDIFACT, EDI, etc.)
ADO to XML
The Stylus Studio ADO to XML data coversion wizard simplifies extracting of relational data into any XML format.