Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference DBLOOKUP
Functions and Expressions Reference Guide
89
Uses
Use
DBLOOKUP to execute an SQL statement when you want to execute a
SELECT statement to retrieve a specific column value in a large table in a
database using the value of another input, rather than defining the entire table
as an input card and using the
LOOKUP, SEARCHDOWN, or SEARCHUP functions.
Use DBLOOKUP to execute an SQL statement when you want to execute a
SELECT statement to retrieve a specific column value from a table or database
that might vary based on a parameter file. Using Meaning 2 of the
DBLOOKUP
function allows these parameters to be dynamically specified at run time.
Related Functions
DBQUERY, EXTRACT, FAIL, LASTERRORCODE, LASTERRORMSG, LOOKUP,
SEARCHUP, SEARCHDOWN, VALID