Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

QUERY# returns a Telitab subset on the basis of a set of search criteria

Syntax

QUERY#(Telitab$, UnfoldPar$, Arg_1$[:ParLab_1$], .., Arg_n$[:ParLab_n$])

Arguments 

  • Telitab$ is Telitab$ is a string expression containing/returning a Telitab set.
  • Unfold/SortPar$ is a name of parameter for which to unfold and subsequently sort a dataset. For expalation on unfold see also the UNFOLD#();
  • Arg_1$[:ParLab_1$], .., Arg_n$[:ParLab_n$] are the query arguments. These can be string parameters or string values.

...

The list Arg_1$[:ParLab_1$],,,,Arg_n$[:ParLab_n$] contains a set of values or criteria for which a set of records has to be selected from the source data Telitab$.

Again we use Telitab_1$ with the query:

DATASET$ = QUERY#(Telitab$, "LPP", ARG1$: "LPP", ARG2$: "T")

...