OBJECT Argument

Use the OBJECT argument to create an object variable for the record retrieved by the SELECT command.

OBJECT(<name>)

where <name> is the name of the object variable to be created.

The record that is found creates a complete set of object variables containing all the record information, using the object name as the prefix.

For example, the following request creates a set of object variables named @DAILY, which will contain the data for the record that is retrieved. Therefore, !@DAILY-ADID would resolve to the application name of the retrieved record.
SELECT AD ADID(DLYAPPL) OBJECT(DAILY)