An LUDB (Logical Unit Data Base) function is a Project function invoked from an SQL query to perform more complex operations on an LU or reference data than those performed using standard SQL statements.
To create an LUDB function, refer to the steps in How to Create Project Functions.
When creating an LUBD function, make sure that:
String sql =
"SELECT CUSTOMER_ID, ACTIVITY_ID, ACTIVITY_DATE, ACTIVITY_NOTE, fnCreateInstId(?) IID FROM Customer.ACTIVITY";
Db.Rows rows = ludb().fetch(sql,input);
for (Db.Row row:rows){
yield(row.cells());
}
A full example of fnCreateInstId LUDB Function can be found in the Demo project.
An LUDB (Logical Unit Data Base) function is a Project function invoked from an SQL query to perform more complex operations on an LU or reference data than those performed using standard SQL statements.
To create an LUDB function, refer to the steps in How to Create Project Functions.
When creating an LUBD function, make sure that:
String sql =
"SELECT CUSTOMER_ID, ACTIVITY_ID, ACTIVITY_DATE, ACTIVITY_NOTE, fnCreateInstId(?) IID FROM Customer.ACTIVITY";
Db.Rows rows = ludb().fetch(sql,input);
for (Db.Row row:rows){
yield(row.cells());
}
A full example of fnCreateInstId LUDB Function can be found in the Demo project.