call-for-papers

The following is a list of lookup and reference functions.

Function Description

CHOOSE Returns the object within a series whose position (index) in the series corresponds to a specified number.

DBLOOKUP Executes an SQL statement against a database, returning the results excluding the final column delimiter and row terminator.

Note The DBLOOKUP and DBQUERY functions are only available when used with a corresponding database adapter.

DBQUERY Executes an SQL statement against a database.Note The DBLOOKUP and DBQUERY functions are only available when used with a corresponding database adapter.

DDEQUERY Allows interfacing to other Windows applications.

EXTRACT Returns each member of a series for which a specified condition is true.

GETANDSET Gets a fixed length value from the input data stream, updates that value in the input data stream, and returns either the original or updated value.

GETDIRECTORY Returns the full path (directory) for the compiled map or the source or destination associated with a specified card object.

GETFILENAME Returns the file name of a file source or target of a specified card object.

GETPARTITIONNAME Returns a text item whose value is the name of the partition to which the data belongs.

GETRESOURCENAME Returns the adapter source or target command of a specified card object.

INDEX Returns an integer that represents the index of an object relative to its nearest contained object, counting only valid objects.

INDEXABS Returns an integer that represents the index of an object relative to its nearest contained object, counting both valid and invalid instances of the object.

LASTERRORCODE Returns a text item whose value is the last error code returned by one of a specified set of functions during map execution.

LASTERRORMSG Returns a text item whose value is the message corresponding to the last error code returned by one of a specified set of functions during map execution.

LOOKUP Sequentially searches a series, returning the first member that meets a specified condition.

MEMBER Looks for a specified object in a series. If found, returns TRUE; otherwise, returns FALSE.

SEARCHDOWN Performs a binary search on a series sorted in ASCII descending order, returning a related object that corresponds to the item found.

SEARCHUP Performs a binary search on a series sorted in ASCII ascending order, returning a related object that corresponds to the item found.

SORTDOWN Returns a series containing the values from an input series in ASCII descending order.

SORTUP Returns a series containing the values from an input series in ACII ascending order.

UNIQUE Searches a series, returning all members that are unique.