jBase Query Language 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.

Command Syntax

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

Comments : When the Command terminates, it displays the total number of entries in the generated list and makes the list available as if 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, it uses the default data definitions "1", "2" etc.

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