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

User login

Frontpage Sponsor


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: 65

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 7th December 2017, 04:48
kingsley143's Avatar
kingsley143 kingsley143 is offline
Join Date: Feb 2008
Location: INDIA
Posts: 34
kingsley143 is on a distinguished road
Baan: Baan LN 6.1 - DB: Microsoft SQL server 2000 - OS: windows server 2003
Difference between DAL and UE


I am new to LN, I want to know the difference between DAL, DAL2 and UE in LN.
In which case we use DAL,DAL2/UE. Please help.

Thanks in advance.
Reply With Quote
Old 26th December 2017, 03:09
jeffersyuan jeffersyuan is offline
Senior Member
Join Date: Jan 2006
Posts: 285
jeffersyuan is on a distinguished road
Baan: B4,B50C, LN FP1-FP10 - DB: SQL Server , Oracle - OS: Window , Unix , AIX

To be simply, DAL and DAL2 means, you can use it for your own table.
However, the UE means, you do not have the source code, you can do some extends.

The Simply is The Best
Reply With Quote
Sponsored Links
Old 9th January 2018, 14:06
bdittmar's Avatar
bdittmar bdittmar is offline
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,766
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
UE UserExit


A User Exit DLL (UEDLL) is a DLL that will reside outside the standard software.
It will have the same name as a standard DAL with the extension ‘ue’ (for ‘user exit’). 
E.g. ‘whinh200ue’ for table whinh200. Customers can implement a UEDLL in order 
to be able to define extra business logic before and after 
the standard ‘before’ and ‘after’ handling of

saves and deletes, by means of specific hooks that will be executed by the 4GL engine 
and/or DAL Engine. In this way it is possible to e.g. conditionally publish 
data changes to the outside world.

Interaction with 4GL Engine / DAL Engine

When present, the User Exit DLL for a certain table will be loaded by the 4GL engine/DAL 
Engine by the time the DALfor 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 UEDLL.


A DLL becomes a UEDLL when it meets the following conditions:
•Its name is consisting of the table code with ‘ue’ as suffix, like whinh200ue
•It includes bic_dal, as follows: #include <bic_dal>


A UEDLL 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 UEDLL Instead the business logic 
should be programmed in another (separate) general DLL.
•It is strongly discouraged to define other external functions in a UEDLL and 
link the UEDLL directly to other scripts. Instead, use a normal general DLL. 
(This also applies to regular DALs).

User Exit Hooks

A UEDLL script can contain the following hooks:

Reply With Quote
Old 17th January 2018, 11:10
Ajesh's Avatar
Ajesh Ajesh is offline
Join Date: Feb 2009
Posts: 616
Ajesh is on a distinguished road
Baan: LN 10.4 - DB: Oracle - OS: HP-Unix
No Difference in their hooks only User exit Hooks gets called before or after DAL Hooks depending on the UE Hook which is being called.

For example, gets called before and gets called after
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

All times are GMT +2. The time now is 12:44.

©2001-2018 - -