Find below the list of common variables used in subroutines. They’re accessible as long as you include “$INSERT I_COMMON” in
Tag: subroutine
DEBUGGER
2 ways to invoke the debugger: launching debugger once a program is called and reaching a specific line number:
Update a record in live & history file during EOD/COB
Just an example of elements to include in a routine that update a record during the COB (end of day
Number(s) Formatting
First thing to note: native data is string in Jbase. So if you start with multiplying your data by 1,
Core Accounting
CORE ACCOUNTING Main table: CONSOLIDATE.COND Audit Track Focus on DX module CORE ACCOUNTING MAIN TABLE: CONSOLIDATE.COND The financial
Function usage
JBase-Basic allows the definition of functions, like in any standard programing language. Benefit is that programs calling functions are much easier to read
Dynamic array versus matrix
Within a jBase-Basic program, a data array can be represented as a Dynamic Array: – Used with array_name<datax> or alternatively
Write trace in a log file
Sometimes you need to add some program traces in a log file to understand more clearly what is going on.
“black belt” LIST command under Jbase
SQL: select left(value_date,6), count(*) from security_transfer where broker_no = ‘595701’and transaction_type like ‘F%’ and value_date like ‘2010%’ group by left(value_date,6)
Produits Dérivés: les Options
Introduction Les Options – Définitions Les différents types d’options Objectifs poursuivis Stratégies d’options Stratégies spécifiques aux options de taux Introduction
FX Options Products
Introduction Options – Definition Options strategies ————————————————————————————- Introduction Derivatives markets or products are named ”Derivatives” because they are “derived”
Marché des Changes
MARCHE DES CHANGE Notions de base Certain / incertain Dans la plupart des pays, on cote les devises étrangères contre
Produits de taux d’intérêts
Le Marché Monétaire Notions et principes de base Les Prêts et Emprunts Introduction amortissables pension fiduciaires Le Marché des Capitaux
Mise en place du module Swap
Ce document présente : Overview de SWAP.TYPE (paramètres) Overview de SWAP.PARAMETER (paramètres) Saisie d’un contrat type IRS (fixed/floating) Marked to
Swap module setup
Swap module documentation SWAP Data Model SWAP.TYPE Overview (parameters) SWAP.PARAMETER Overview (parameters) Example of IRS deal capture (fixed/floating) Detailed Marked
Securities Concat Files
List of Securities Concat Files Starting with a client code from CUSTOMER.SECURITY, we have all portfolios declared in SEC.ACC.MASTER. All
Module Repo
1.Introduction Ce module permet de saisir des contrats de REPO et Reverse REPO, avec des contreparties bancaires, des intermédiaires (banques
Position Management
Ce document présente les principales fonctionnalités liées au module PM. Cette application « horizontale » a pour but de mettre
Past Due Payments
This document describes the general steps for Past Due Payments module implementation. Example of PD.PARAMETER record
Relevé de compte Nostro
OBTENTION D’UN EXTRAIT DE COMPTE (PAPIER) ET D’UN MT950 T24/Globus offre la possibilité de produire un extrait papier et un
Netting Payment
Module NETTING : Présentation sommaire NETTING.AGREEMENT : Déclaration des banques pour lesquelles il existe des accords de netting, incluant Code
Money Market
MONEY MARKET This module is designed for the multicurrency assets and liabilities transactions of a commercial bank. The main deal
Garanties
PARAMETRAGE DU MODULE – GARANTIES– Ce document présente différents éléments de paramétrage du module MD.DEAL – GARANTIES – 1.Table de
Multi-company
SET UP MULTI COMPANY ENVIRONMENT The steps to set up a multi company environment are given below. The same steps
Funds Transfer
Funds Transfer Application Cash Pooling Funds Transfer Application The Funds Transfer Module is designed to handle all types of Local
Transferts
Procédure SIC Paiements Multiples Procédure SIC FT.BC.PARAMETER Définition des règles pour chaque type de compensation – Validation, formatage, les routines
Forward Rate Agreement
Règles Comptables applicables aux contrats de FRA Trading et Hedging. Introduction Les types de FRA “Trading” ou “Hedging” vont déterminer
Forex
REEVALUATION FOREX REVALUATION.PARAMETER REEVALUATION FOREX Principes de comptabilisation de la réévaluation de opérations de change. Préambule 1.
Fiduciary Deposits – Module description
Fiduciary Application This application is used by dealers to place fiduciary deposits made by customers with other banks. The placement
Multivalued fields
Multivalued fields This is a very specific characteristic attached to the RDBMS included with GLOBUS / T24 ( Universe or
Create a new application, starting from a standard TEMPLATE
If the standard package is not enough for you, you can easily create a new application from scratch 🙂 Steps
Display messages to the user
Display a simple message Example of coding: TEXT = “Your input overrides tolerance of” TEXT := “<CR>” TEXT :” MAX.TOL
Example of a script launching an URL from a version
Example of SCRIPT Designer : LOAD.DX.LINK Dim sAppName Dim MyCommand Set oApp = Desktop.GetCurrentWindow sID = oApp.ID Select Case sID
JBase Programmer’s Guides
Programmers_Reference_Manual.pdf: Advanced Programmers Reference Manual.pdf :
How to modify the default enrichment of a field
(to be used in a version) STANDARD.SELECTION Create an I-desc that contains the new enrichment DX.CONTRACT.MASTER 15. 5 USR.FIELD.NAME. SHORT.NAME.SIZE
Validation routine in a Version
In a version, you can manipulate fields contents by using a validation routine. It is defined in a version using
Jbase Editor tips & tricks
Quit Editor after multiple select After a SELECT + EDIT / jed, to quit the editor: Escape !EXK + Return
Dates Manipulation
Get detailed date time information: * Time HH:MM:SS DD MMM YYYY CURRENT.TIME = TIMEDATE() CURRENT.TIME = CURRENT.TIME[1,2]: ‘:’ : CURRENT.TIME[4,2]:
Write directly a record in a table
WRITE “R.RECORD” TO “F.TABLE.NAME”, “RECORD.KEY” Example : FN.DX.MARKET.PRICE = “F.DX.MARKET.PRICE” F.DX.MARKET.PRICE = “” CALL OPF(FN.DX.MARKET.PRICE, F.DX.MARKET.PRICE) (…) WRITE R.DX.MKT.PRICE TO
Write properly a record in a table (CALL F.WRITE)
CALL F.WRITE (FN.TABLE.NAME, RECORD.ID, R.RECORD) Example : FN.FILENAME = ‘F.FILENAME’ ; FV.FILENAME = ” CALL OPF(FN.FILENAME, FV.FILENAME) R.RECORD<DX.CM.FIELD1> = ‘TOTO’
Build and fill in an array then retrieve data from it
Sometimes you will need to temporarily store data, before aggregation, cumul, re-order, etc… An array is the solution to perform
Read an History file with a Live key
Read an History file with a Live key Use the program EB.READ.HISTORY.REC to read the history file. You take the
Return a list of keys with a QSELECT
CALL EB.READLIST can also be used with a QSELECT. The QSELECT is selecting all fields from a table, not only
Return a list of keys after a SELECT (CALL EB.READLIST)
CALL EB.READLIST (SELECT.STATEMENT, KEY.LIST, LIST.NAME, SELECTED, SYSTEM.RETURN.CODE) Routine to return a list of keys from a select statement. Introduced to
Extract a range of keys after a CALL OPF(FOR NEXT, LOOP REMOVE)
Extract a range of keys after a CALL OPF Y.DATE = TODAY READ R.DX.DAILY.TRANS FROM F.DX.DAILY.TRANS,Y.DATE ELSE R.DX.DAILY.TRANS = “”
Alter the Handoff with a subroutine
Introduction to T24 HANDOFF file. The Handoff is a file populated by a core T24 program (EB.HANDOFF) . It is
Delivery
Delivery Module Introduction Let T24 producing SWIFT messages without releasing them outside How to resubmit an advice How to check
DX Overview
The GLOBUS Derivatives product has been developed to allow trading of futures and options. The product supports orders, trading, position
DX Pricing & Prices
Manual prices input External feed of prices (such as Reuters / Telekurs / Bloomberg / etc…): this for all quoted
DX concat files
DX Concat Files This chapter briefly describes all useful concat files that may be used either in enquiries or subroutines.
Manipulate the fields of a table (quick introduction)
All fields from a table are numbers, with an associated description. This association is set in libraries loaded by
Get a foreign data from a local table (CALL DBR)
Get a foreign data from a local table When you work with a table, you may need information stored in
Call a subroutine from an enquiry field
Call a subroutine Usage description: You can call a subroutine from an enquiry field. You have to invoke it using
Display the very first inputter of a record / a deal
Display very first inputter of a record 12. 7. 1 OPERATION… INPUTTER 13. 7 COLUMN……… 52 14. 7 LENGTH.MASK…. 28L
dates formatting
Example of date formatting in Enquiry 12. 3. 1 OPERATION… DATE.TIME 13. 3 COLUMN……… 35 14. 3 LENGTH.MASK…. 10L 15.
Compute the difference between two dates
You have first to convert the two dates to be compared to the julian format. 11.19 FIELD.NAME….. LAST.TRADE 12.19. 1
How to deal with selection fields in an enquiry targeting a Nofile
Selection fields in an enquiry targeting a Nofile If you need to give users the ability to filter the enquiry
Build an enquiry with a Nofile
Build an enquiry driven to a NOFILE When you can’t use standard conversion / calculation functions to get what you
Get a whole record, then extract multiple fields (CALL OPF, CALL F.READ)
CALL OPF, CALL F.READ
This is How Globus Works
This is How Globus Works…