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?

Conversion Processing

  • A Correlatives Description  A codes provide many powerful features. These include arithmetic, re
  • B Conversion Provides interface for jBC subroutines or C functions to manipulate data during j
  • C conversion Description  Concatenates fields, literals, and the results of a previous operati
  • D Conversion Description  Converts dates between internal and external format. It takes the ge
  • D1 D2 Conversion Description Associates controlling and dependent fields. It takes the form: D1;fm
  • F Correlatives Description  F codes provide many facilities for arithmetic, relational, logical,
  • G Conversion Description  G codes extract one or more contiguous strings (separated by a speci
  • JBCUserConversions Conversion Code Extensions With jBASE it is possible to extend the scope of the c
  • I Types Description  The jBASE jQL processor supports I-TYPES as imported from PRIME or U
  • L Conversion Description  L codes return the length of a value, or the value if it is within s
  • MC Conversion Description MC codes include facilities for: changing characters to upper or lowe
  • MD Conversion Description The MD code transforms integers by scaling them and inserting symbols
  • MK Conversion Description  The MK code allows you to display large numbers in a minimum of colu
  • ML/MR Conversions Description  ML and MR codes format numbers and justify the result to the left or
  • MP Conversion Description  MP codes convert packed decimals to unpacked decimal representation
  • MS Conversion Description  The MS code allows an alternate sort sequence to be defined for sort
  • MT Conversion Description  The MT code is used to convert time notations such as 01:40:30 or 1:
  • P Conversion Description  The P code returns a value if it matches one of the specified patter
  • R Conversion Description  The R code returns a value that falls within one or more specified r
  • S Conversion Description  The S code substitutes one value for another. It is as:  S;Var1;Var2
  • T Conversion Description  The T code extracts a character substring from a field value. It tak
  • Tfile Conversion Description  Tfile codes provide a method for retrieving data fields from any oth
  • U Conversion Description  The U code is used to execute a system subroutine to process values.
  • Conversion Processing A Algebraic functions. B Subroutine call. C Concatenation. D Internal and externa
  • Field Number (FMC) Operand Description Specifies a field which contains the value to be used. It takes the f
  • N (Field Name) Operand Description  References another field defined by name in the same dictionary or f
  • Literal Operand Description  Specifies a literal string or numeric constant enclosed in double qu
  • System Parameter Operands Description Reference system parameters like date, time, the current break level,
  • Format Codes Description  Specifies a format code to be applied to the result of the A code or
  • User Exits Description  jBASE provides support for the legacy user exit construct. In additi
  • Supported User Exits U3060     Encrypt a string. U307A     Sleep U407A     Sleep U50BB     WHO U60BB