Data Transformation Engine Functions and Expressions Reference Guide
Chapter 3 - Function Reference PUT
Functions and Expressions Reference Guide
166
Uses
Use
PROPERCASE to convert the first alphabetic character in each word to
uppercase and all remaining characters to lowercase.
Related Functions
ISALPHA, ISLOWER, ISUPPER, LOWERCASE, UPPERCASE
PUT
The PUT function passes data to a target adapter.
Note The PUT function has a scope of Burst.
Syntax
PUT (single-text-expression , single-text-expression ,
single-text-expression)
Meaning
PUT (adapter_alias , adapter_commands ,
data_to_send_to_adapter)
Returns
This function returns NONE.
The adapter identified by adapter_alias is called using the specified
adapter_commands and passing data_to_send_to_adapter as data to the
adapter.
When the
PUT function is used, the following settings are used by default. Note
that the default OnSuccess action is adapter-specific. The adapter-specific
OnSuccess defaults are listed in Adapter Commands Aliases in the Resource
Adapters Reference Guide.
♦ OnSuccess – Adapter-specific
♦ OnFailure – Rollback
♦ Scope – Burst
Use the
VALID function with the PUT function to identify whether the PUT
function executed successfully and to react accordingly.