Welcome to jBASE's new documentation site! Many answers to your questions can be found by searching the Knowledgebase or viewing the jBASE Documentation. We also have a Google Group for peer discussion about jBASE. If you are unable to find the information you are looking for, jBASE Support will be glad to assist in resolving your technical problems. Enjoy and please provide comments and feedback .

How can we help you?

BSELECT

Description

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.

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

 

Note: 

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 a sort-criteria clause is not specified, the record list will be unsorted. If an output-specification is not specified, the default dictionary definitions "1", "2", "3",... will be used.

For instance :

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.

Back to JQL

Was this article helpful?