TABLE-HANDLE definition for all dynamic temp-table parameters

TABLE-HANDLE parameters pass both the schema and data, because the dynamic temp-table schema is not known at compile time. Thus, for TABLE-HANDLE parameters, OpenEdge Web services map an ABL TABLE-HANDLE to a <complexType> containing a sequence of xsd:any. There is a single definition used for all TABLE-HANDLE parameters in all supported SOAP formats. The following WSDL sample shows this common TABLE-HANDLE parameter definition:

<complexType name="TableHandleParam">
  <sequence>
    <any namespace="##local"/>
  </sequence>
</complexType>

The client application must create (for input) and parse (for output) the XML Schema along with the data for the parameter. How the client inserts the input schema and data in request messages and how it parses the output schema and data from response messages is entirely dependent on the client toolkit.

Each column of a TABLE-HANDLE row can hold any data type shown in the following table.

ABL data type XML Schema data type
CHARACTER xsd:string
DATE xsd:date
DATETIME-TZ xsd:dateTime
DECIMAL xsd:decimal
INT64 xsd:long
INTEGER (32 bit) xsd:int
LOGICAL xsd:boolean
RAW xsd:base64Binary