BSELECT

Retrieves selected records and generates a list composed of data fields from those records as specified by any explicit or default output specifications. Each subvalue within a field becomes a separate entry within the list.

SYNTAX

BSELECT file-specifier {record-list} {selection-criteria} {sort-criteria} {USING file-specifier}{output-specification} {(options}

NOTES

When the command terminates, the total number of entries in the generated list is displayed and the list is made available as if it had been generated by a SELECT, GET-LIST or other list-providing command.

If you do not specify a sort-criteria clause, the record list will be unsorted.

If you do not specify an output-specification, the default data definitions "1", "2" etc. will be used.

EXAMPLE

BSELECT SALES WITH S.CODE = "ABC]" P.CODE

Creates a list containing all P.CODE values from all the records in the SALES file which have an S.CODE that starts with ABC.

jQL