Sunday, July 30, 2023

OBJ and RDB Methods

 OBJ Methods


Obj-Save-Cancel will cancel the immediate member of uncommitted Obj-Save in the differed queue.

Rollback will cancel all the DB methods which are not committed prior to the method step in the differed queue.


RDB Methods


There are 4 main variations in RDB methods where we need to provide mandatory parameters when calling.

  1. RDB-List --> Obj-browse
  2. RDB-Delete --> Obj-Delete
  3. RDB-Save --> Obj-Save
  4. RDB-Open --> Obj-Open

Mandatory parameters

  • Class Name - The class which is corresponding to datatable
  • RequestType - This refers to the ConnectSQL rule. In practice it is possible to define separate ConnectSQL for each RDB method or alternatively we can define all the RDB methods in the same ConnectSQL rule since we have separate tabs for each RDB method.

  • Access - Which is about which type of Database type we are connecting to eg:- Oracle, PostgreSQL, MySQL etc. we set it as All allowing all types of Databases.



Why do we use RDB methods?

Sometimes it's a bit difficult to create a query using obj methods due to complexity. In such situations we go for RDB methods we can directly write the query inside it which also improve the performance also since it will save the time to generate the SQL query also.

No comments:

Post a Comment

Rule Delegation

 Summary of Rule Delegation The purpose of Rule Delegation is to make the rule available in the production environment for customization for...