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?

JQL

jBASE Query Language (jQL) retrieves data from the database in a structured and formatted manner.

  • JQL Overview  The jBASE Query Language (jQL) is a powerful and easy to use facility w
  • Defaults Alternative Dictionaries In order to enable dictionary definition records from mu
  • BSELECT Description Retrieves selected records and generates a list composed of data fiel
  • COUNT Description Reports the total number of records found in a file that match the se
  • EDELETE Description Deletes selected records from a file according to record list or sele
  • ESEARCH Description Generates an implicit list of records in a file if they contain (or d
  • I-DUMP / S-DUMP Description The command displays the entire contents of items in a file, includin
  • LIST Description Generates a formatted report of records and fields from a specified f
  • LIST-ITEM Description Displays the contents of items. It takes the general form:  LIST-ITEM
  • LIST-LABEL Description Outputs data in a format suitable for producing labels. It takes the
  • LISTDICT(S) Description Generates a report of all data definition records in the first MD/VOC
  • REFORMAT Description REFORMAT is similar to the LIST command in that it generates a format
  • SELECT Description The statement generates an implicit list of record keys or specified
  • SORT Description Generates a sorted and formatted report of records and fields from a
  • SSELECT Description SSELECT generates an implicit list of record keys or specified fields
  • SORT-LABEL Description Outputs data in a format suitable for producing labels.  It takes the
  • jBASE Query Language (JQL) Overview  Defaults  Conversion Processing Subroutines File Definitions I Types  J
  • Subroutines jBASE jQL enables users to call Basic subroutines from within correlatives and co
  • File Definitions Description File definition records contain information that is used when formatt
  • SUBLISTS - V CODE Description File records which contain sublists can be accessed with the COUNT an
  • Data Definition Records - Dictionary Structure Description Dictionary definition records (sometimes known as data or field defin
  • SREFFORMAT Description SREFORMAT is similar to the SORT command in that it generates a forma
  • Calling a Subroutine from a Dictionary Item Description It is possible to have dictionary items call subroutines. This can be