Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference GET
Functions and Expressions Reference Guide
115
If a source adapter error occurs,
GET returns NONE. Use the VALID function
with the
GET function to identify whether the GET function executed
successfully and to react accordingly.
Examples
Reply (s) = GET ( "ROMA", "-BE Orders22A -MID 32001 -REQ 2",
PACKAGE (Request Object:.:Input)
In this example, the
GET function could be used in a request/reply mode to get
information from a Roma messaging system.
Acct# = GET ("DB" , "-dbtype ORACLE –connect shasta –user rjc
–pw vm70" + "SELECT Acct# FROM CustMaster WHERE CustID = '" +
SenderID Field:Identification Segment:Msg + "'")
In this example, the GET function could be used instead of a DBLOOKUP or
DBQUERY function to retrieve data from a database from within in a map rule.
Uses
Use
GET to retrieve using one of the source adapters, such as a messaging
system, a database, a file, and so on, within the course of your map.
Related Functions
FAIL, LASTERRORCODE, LASTERRORMSG, PUT, VALID