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?

File Definitions


File definition records contain information that is used when formatting reports. For example, should the key field of a file be left or right justified, and how wide a column should it occupy. You can also define sublist codes to tell the system that a particular field is multivalued. 

This section starts with a review of file definition records and discusses how the content of these records can affect the output from jQL commands - particularly with reference to sublists.


Record Structure 

The fields of a file definition record that affect jQL reports are:

Field 7
Conversion code for key, if required. For date, time, etc.
Field 8
V code to notify a multivalued (sublist) field, if required. See Sublists - V Code.
Field 9
Justification for key. Can be one of the following (see Data Definition Records):
L Left justified
R Right justified
T Text
U Unlimited
Field 10
Column width for key. Default is 14 characters. Also see JBCIDLEN.

Back to jBASE Query Language (JQL)

Was this article helpful?