1. Welcome to the “Introduction to jBASE Database” learning unit.

In this learning unit,

you will learn the basics about jBASE

JBS1. Introduction to jBASE Database-R15 1

 After completing this learning unit, you will be able to:

•Explain what is jBASE

•Analyze a simple T24 Architecture
•Analyze jBASE directory structure
•State the purpose of the .profile/remote.cmd file
•Analyze jBASE environment variables

JBCRELEASEDIR, JBCPORTNO, JBCGLOBALDIR, PATH,

LIBPATH, JBCSPOOLERDIR, JEDIFILENAME_MD, JBCLISTFILE, JBCEMULATE,
JBASE_ERRMSG_DIVIDE_ZERO, JBASE_ERRMSG_ZERO_USED,
JBASE_ERRMSG_NON_NUMERIC

JBS1. Introduction to jBASE Database-R15 2

 •From Release R9, jBASE releases used by Temenos are known as TAFC (Temenos
Application Framework C)
•Like any other database system, TAFC could be thought of having two sides to it – the
database and the runtime
•The term jBASE is used with respect to the database and it’s file system.
•TAFC is used refer to the runtime

JBS1. Introduction to jBASE Database-R15 3

 1. jBASE Database is
1.1 A Post Relational Database Management System. It supports multi value
and sub value, they are Non fixed length fields.
1.2 A Development environment. It comes with a programming language
called jBASE BASIC. jBASE can be used to create ,compile and execute
programs
1.3 An extension of the operating system. The jsh(jshell) provided by jBASE
can execute most of the operating system commands)
1.4 An Open database. It can communicate to other databases using Direct
Connect Drivers
1.5 It Uses the ‘C’ compiler to compile code
1.6 T24 uses jBASE Database to store data. jBASE provides a run time
environment (Like JRE in java). T24 resides on the jBASE Run Time
Environment. The runtime enables T24 to communicate with the jBASE
database

JBS1. Introduction to jBASE Database-R15 4

 What you see here is a simple T24 Architecture.

1. The first layer of the T24 Application Server is the operating system like UNIX,
Windows etc.
2. jBASE is installed in the second layer, above the Operating System. When jBASE
is installed, the database and the run time commonly referred to as TAFC, get
installed together.
3. T24 is installed above jBASE. TAFC acts as a runtime for T24. TAFC helps T24 to
communicate with the jBASE database
4. The User layer can either be a terminal emulation software, Globus Desktop or
T24 Browser.

JBS1. Introduction to jBASE Database-R15 5

 Logging onto TAFC

Whenever a user wishes to log on to T24 running on TAFC, the steps would be
1. Logon to Windows by specifying a username and password.
2. Once the Windows username and password are verified, the remote.cmd file
(.profile in case it is a UNIX server) under the home directory of the user is
executed. It is in this remote.cmd file that TAFC environment is setup and the user
is taken to T24.

For more details on this, refer documentation on ‘T24 directory structure and important
files in T24’

JBS1. Introduction to jBASE Database-R15 6

 TAFC has a directory structure similar to that of UNIX.

bin : Contains all the binary executable that make up the TAFC system including the
compilers.
config: Contains various configuration files relating to the jPML daemon(discussed
later in this section), the configuration file for the creation of library files(Discussed in
the session ‘Infobasic Programming ‘) and other configuration files.
lib: Contains the library files that are required for the working of TAFC. This directory
contains all the libraries required for linking and executing jBC-compiled routines.
Shared or Dynamic libraries are also stored here. Library files stored here are similar
to dynamic link libraries (.dll) files in Windows.
tmp: This is a general purpose temporary directory for runtime use.
jspooler: This is the spool directory of TAFC . It contains all the files that are required
for spooling to work in TAFC . This directory is created as a part of the printer setup of
TAFC and does not get installed when TAFC is installed. You should create this
directory manually.

JBS1. Introduction to jBASE Database-R15 7

 1. Change to directory where TAFC has been installed and list the contents of the
directories that you have just learnt

JBS1. Introduction to jBASE Database-R15 8

 Logging into jBASE

1. After supplying a valid user name and password, a port number is assigned to
each user.
2. All users are assigned a port when they log on to the server, jBASE assigns port
when user logs in Port numbers are picked up from a file called “port0-499” found
under the “$JBCRELEASEDIR/proc” directory.
3. The list of ports that can be assigned are defined in the file named “port0-499”
found under the “proc” directory under the folder where jBASE is installed.
4. Set the environment variable JBCPORTNO in the .profile to a certain value if you
always want to use a particular port number
JBCPORTNO = 1000-1005
JBCPORTNO = 1000,1001,1002,1003,1004,1005

JBS1. Introduction to jBASE Database-R15 9

 TAFC_HOME Environmental Variables

It contains the path where TAFC is installed.

TAFC_HOME=C:\R12\Temenos\TAFC

JBS1. Introduction to jBASE Database-R15 10

 JBCPORTNO

1. This variable holds information of the allowed port numbers that can be used by
jBASE to login to the system.

2. jbcconnect was used earlier to connect to jBASE. This variable was set in
remote.cmd – “set jbcconnect”. This needs to be commented out as its now
included in jBASE itself. We need to set the JBCPORTNO variable in .profile or
the remote.cmd file.

3. set JBCPORTNO = 0-150

3.1 The above setting done in remote.cmd will restrict jBASE to use only port
numbers from 0 to 150.

JBS1. Introduction to jBASE Database-R15 11

 JBCGLOBALDIR
It contains the path of the config directory(discussed earlier in this section) of jBASE.
jBASE refers this variable when it needs to refer/read configuration files. Usually it
points to the same path as that of JBCRELEASEDIR as the config directory is present
there.
Example: JBCGLOBALDIR = /usr/jbc

JBS1. Introduction to jBASE Database-R15 12

 PATH

1. It is an environment variable in UNIX which is used by TAFC.

2. It contains the search path of TAFC executables. Here apart from containing the
search path of UNIX executables, it will also contain the search path of TAFC
executables. As you would be aware, the bin directory under the directory where
TAFC has been installed contains all the TAFC executables. Therefore, this
variable would point to that bin directory.
PATH=$PATH:/usr/jbc/bin
3. Note that the search path of TAFC executables has been appended to the existing
contents of the PATH variable.

JBS1. Introduction to jBASE Database-R15 13

 LIBPATH
1.1, 1.2, It contains the path of the TAFC library files. As you would be aware by now,
the TAFC library files are stored under the lib directory, which is under the directory
where TAFC has been installed. Therefore this variable would point to that lib
directory.

LIBPATH = /usr/jbc/lib

1.3 Note that the variable LIBPATH needs to be used only for AIX machines. Use
SHLIB_PATH for HP and LD_LIBRARAY_PATH for all other types of machines to
store the path of TAFC executables.

JBS1. Introduction to jBASE Database-R15 14

 JBCSPOOLERDIR
It contains the path of the spool files of TAFC. As discussed earlier, the jspooler
directory under the directory where TAFC has been installed holds all the spool files of
TAFC . Therefore this variable would point to the jspooler directory.
It is the decision of the system administrator whether to keep the jspooler directory
under the directory where TAFC has been installed or move it to a common location
like /usr. In the first case, the jspooler directory becomes jBASE release specific. All
users working in that specific release of TAFC would be using that jspooler directory.
In the second case, irrespective of the release of jBASE that the user is using, all of
them will use a common tmp directory. In the below mentioned example the jspooler
directory has been moved to a common location, has been given the correct
permissions as every jBASE user needs to access it.

JBCSPOOLERDIR=/usr/jspooler

JBS1. Introduction to jBASE Database-R15 15

 1. Display the contents of the TAFC variables that you have just learnt
2. Use echo $<variablename> to display the contents of variables.

JBS1. Introduction to jBASE Database-R15 16

 JEDIFILENAME_MD
Each jBASE account has a vocabulary file called the VOC file. The VOC file contains
entries that identify every verb, sentence, paragraph, file, keyword, and menu that you
can use while you are in a jBASE account. The command processor uses the VOC
file to decide what action to take when you enter a command. The VOC (Vocabulary)
file can also be called the MD, Master Dictionary.
JEDIFILENAME_MD=$HOME/VOC

Sample Commands Pertaining To VOC

LIST VOC This will list all the entries in the VOC file
Q Quit process

Types Of VOC Entries

F File definition
K Keyword
M Menu Record
PA Paragraph
D Remote file pointer
S Sentence
V Verbs (commands)

JBS1. Introduction to jBASE Database-R15 17

 LIST VOC WITH TYPE = ‘F’ can be used to see all the ‘File’ type VOC entries.

JBS1. Introduction to jBASE Database-R15 18

 Paragraph: A paragraph is a series of sentences stored together with one name.

Consider that you wish to create a script that will automatically launch EX program,
provide the T24 User Name and Password and sign in. You can create a VOC entry of
type PA as shown in the example.

Use the command JED VOC LOGIN, where JED is the command to invoke the JED
editor, VOC is the file name and LOGIN is the name of the paragraph entry.

Line1: PA specifies that you are creating a paragraph entry

Line2: EX is the first sentence. This will launch the EX program
Line3: DATA INPUTT is the second sentence where DATA is a keyword and INPUTT
(T24 sign on name)is the value.
Line3: DATA 123456 is the third sentence where DATA is a keyword and 123456
(Password for INPUTT) is the value.

JBS1. Introduction to jBASE Database-R15 19

 File Pointers: A file pointer is used to point to files

Line1: JED VOC FBNK.CUSTOMER. JED is the command to invoke the JED editor.
VOC is the name of the file and FBNK.CUSTOMER is the name of the file pointer.
Line2: F specifies that it is a file pointer
Line3: Path of the data file
Line4:Path of the dict file

You will learn about data files and dict files when you will learn about the file types
available in jBASE

JBS1. Introduction to jBASE Database-R15 20

 1. List the VOC entries with the type ‘F’

2. Create a VOC entry that will enable you to logon to T24 from the ‘jsh’ prompt.

JBS1. Introduction to jBASE Database-R15 21

 JBCLISTFILE
This is the environmental variable that contains the path of the &SAVEDLISTS&
directory. When a SELECT statement is issued from the database prompt, the output
of the SELECT statement can be saved using the SAVE.LIST command followed by
the name of a file that is to store the selected ids. This file created by SAVE.LIST will
get stored under the &SAVEDLISTS& directory and can be retrieved any time using
the GET.LIST followed by the file name.

JBCLISTFILE=$HOME/&SAVEDLISTS&

Note: This variable can only be changed in the .profile file and not at the prompt.

JBCEMULATE
When clients want to shift from the current database to T24’s native - jBASE, set the
environment variable JBCEMULATE. This variable contains the emulation settings
required by jBASE. Temenos uses PRIME only.

JBS1. Introduction to jBASE Database-R15 22

 1. Save all customers who have sector set to 1000 on to a file named XXX.TRG.LIST
where XXX is your name
2. Check the path where the file XXX.TRG.LIST has been created

JBS1. Introduction to jBASE Database-R15 23

 1. There are environment variables available relating to error message suppression.
The se variables, control the behaviour of run time error message handling for
jBASE programs . By default jBASE will display all the error messages unless
these variables are set.
1.1 Due to programatical errors, jBASE may throw errors at run time. These
errors may appear when
1.1.1 A value is divided by 0
1.1.2 When a null variable is encountered
1.1.3 When a numeric operation on a non-numeric value is
encountered
1.2 To suppress error messages that appear due the above, set the following
variables to 1
1.2.1 JBASE_ERRMSG_DIVIDE_ZERO=1
1.2.2 JBASE_ERRMSG_ZERO_USED=1
1.2.3 JBASE_ERRMSG_NON_NUMERIC=1
Note : When setting the environment variable ensure that you don’t have a space
between the variable and equating it to 1
export JBASE_ERRMSG_ZERO_USED=1 ( correct )
export JBASE_ERRMSG_ZERO_USED = 1 ( incorrect )

Care should be taken when using DIVIDE by ZERO variable because if set we might
miss out on incorrect arithmetic calculations in the programs
These 3 variables supersede the JBASE_WARNLEVEL which was used until jBASE

JBS1. Introduction to jBASE Database-R15 24

 4.0

JBS1. Introduction to jBASE Database-R15 24

 The jdiag utility is used to display information about your TAFC installation. It displays
TAFC environment variables and its values. It is useful in pin-pointing problem areas
of the setup.

JBS1. Introduction to jBASE Database-R15 25

 Use the set command to view the list of variables set

The above screen shot only contains a section of the variables. The ‘set’ command
displays all variables set at the operating system level as well as at the jBASE level
and hence the output would run to multiple pages.

JBS1. Introduction to jBASE Database-R15 26

 1. Execute the commands jdiag and set and view the output

JBS1. Introduction to jBASE Database-R15 27

 (1) FALSE
(2) FALSE
(3) TRUE
(4) TRUE
(5) FALSE

JBS1. Introduction to jBASE Database-R15 28

 1. Holds the directory where TAFC has been installed (b)
2. Holds the path of the TAFC library files ( c )
3. Contains the path of the directory that is used to store select lists (d)
4. Holds the path of the VOC file (e)
5. Contains the path to the config directory of TAFC (a)

JBS1. Introduction to jBASE Database-R15 29

 In this learning unit, you learnt about the basics of jBASE

You will now be able to

•Explain what is jBASE

•Analyze a simple T24 Architecture
•Analyze jBASE directory structure
•State the purpose of the .profile/remote.cmd file
•Analyze jBASE environment variables
JBCRELEASEDIR, JBCPORTNO, JBCGLOBALDIR, PATH, LIBPATH,
JBCSPOOLERDIR, JEDIFILENAME_MD, JBCLISTFILE, JBCEMULATE,
JBASE_ERRMSG_DIVIDE_ZERO, JBASE_ERRMSG_ZERO_USED, JBASE_ERRMSG_NON_NUMERIC

JBS1. Introduction to jBASE Database-R15 30