Go Back > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 34

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 13th February 2018, 22:02
SirBaan SirBaan is offline
Junior Member
Join Date: Feb 2007
Location: Munich, Germany
Posts: 10
SirBaan is on a distinguished road
Baan: BaaN IV, BaaN ERP, SSA LN - DB: Oracle - OS: Unix, Windows
Baan: Other/Unknown
C/S: None/Unknown

Hello Community,
Who can give me some information.
What are the DB DLLs, I mean the DLLs of Type ppmmmxxxdb.
What are they, for what reason are they used, how are they used and how are they built and called by whom. Is there any documentation available?
Any information is highly appreciated.
Thank you in advance.
Reply With Quote
Sponsored Links
Old 14th February 2018, 18:10
NPRao's Avatar
NPRao NPRao is offline
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,073
NPRao will become famous soon enough
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x - DB: Oracle,MS-SQL - OS: HPUX, Linux, Windows
Refer to the latest Programmer's manual -
DB DLL Overview
A DB DLL (DBDLL) is a DLL with the same name as a standard DAL with the extension 'db'. E.g. 'whinh200db' for table whinh200. A DBDLL can be implemented in order to be able to log database actions (insert update or delete) by means of specific hooks that will be executed by the 4GL engine and/or DAL Engine. Stand-alone database operations (not triggered by saves and deletes of the 4GL engine or DAL Engine) are also extended to perform the extra business logic before and after performing the actual database operation. In this way it is possible to log database actions.

Interaction with 4GL Engine / DAL Engine
When present, the DB DLL for a certain table will be loaded by the 4GL engine/DAL Engine by the time the DAL for this particular table will be loaded. In situations where no DAL is present this will be the moment at which a DAL would be loaded if it existed. This means that there is no need to have a DAL in order to make use of the DBDLL.

Interaction with db operations
When one of the following database operations is executed stand-alone (so not as part of the standard save/deletes of the 4GL Engine or DAL Engine):

and the DB DLL for the related table is present, the DBDLL will be loaded prior the database operation. This means that there is no need to have a DAL or a session in order to make use of the DBDLL. During the execution of the hooks (initiated by a database operation) the boolean will be false.

A DLL becomes a DBDLL when it meets the following conditions:

Its name is consisting of the table code with 'db' as suffix, like whinh200db
It includes bic_dal, as follows: #include <bic_dal>
A DBDLL is treated like a regular DAL. This means all kind of DAL related functionality can be used, like:

Pre-defined variable subdal
Note however that the following restrictions apply:

Business methods cannot be implemented in a DBDLL Instead the business logic should be programmed in another (separate) general DLL.
It is strongly discouraged to define other external functions in a DBDLL and link the DBDLL directly to other scripts. Instead, use a normal general DLL. (This also applies to regular DALs).
The execution of db hooks can be enabled/disable with the following commands

DB Hooks
A DBDLL script can contain the following hooks:

Flow of hooks
In case a DAL is involved, as well as a UE DLL, the flow of the hooks is as follows (example of an insert):

1. (in UE DLL)
2. (in DAL)
3. (in UE DLL)
4. db.before.insert (in DB DLL)
5. <actual db.insert>
6. db.after.insert (in DB DLL)
7. (in UE DLL)
8. (in DAL)
9. (in UE DLL)
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
Old 15th February 2018, 20:53
SirBaan SirBaan is offline
Junior Member
Join Date: Feb 2007
Location: Munich, Germany
Posts: 10
SirBaan is on a distinguished road
Baan: BaaN IV, BaaN ERP, SSA LN - DB: Oracle - OS: Unix, Windows
Thank you very much, NPRao.
I had the 10.3 Programmer's Guide and there the DB DLLs are not mentioned.
Now I've downloaded the 10.5 and I got it.
Thank you very much for your advice.

Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
expired dlls in fp7 sa_sch Tools Development 2 7th July 2011 17:50
Functions and DLLs sandyjack Tools Development 8 11th November 2010 11:46
Llamar a DLLs de BAAN desde C++ o Java dani_drio Forum español 1 25th April 2006 06:09
How to see the functions exposed by various DLL's and include files jack786 Tools Development 7 20th July 2004 16:55
Docu: functions --> ERP DLL's spartacus Tools Development 3 19th November 2002 21:17

All times are GMT +2. The time now is 05:14.

©2001-2018 - -