GET

Query Reference Manual

Allows the user to set to data values returned from a data server (using NEXT). Note that all of the standard syntax for setting is available for use within Query.

Also allows the user to store the column headings returned by a data server query in an array variable (using RESULT or HEADER).

Example:

VAR !datarow EXTERNAL GET $!!MAINT NEXT
VAR !header EXTERNAL GET $!!MAINT RESULT

Syntax:

>- VAR varname EXTERnal GET token -+- NEXT -------.
                                   |              |
                                   |- RESult -----|
                                   |              |
                                   ‘- HEADer -----+--->

where:

token is the token for the communication channel which was supplied by a successful EXTERNAL OPEN command (and stored in the token_var variable).

varname will be interpreted automatically as an array variable and each data item will be stored in a separate element of the array. (The PML SPLIT command is not required here; splitting is carried out automatically.)

Note:

RESULT and HEADER commands always return the first row of the result of the last request sent to the data server identified by token (typically, but not necessarily, header information resulting from an SQL database SELECT command).

As with the data fields, no heading should be longer than 120 characters. If a heading exceeds 120 characters, nothing will be returned by the query.