SQL-PL is a development environment of ADABAS D. It can be used to create triggers, DB functions and DB procedures.
The SQL-PL workbench supports the development with an easy-to-use interface, a built-in version manager and a debugger.
The SQL-PL language offers the following facilities:
- Procedural Pascal-like language
- Full SQL language
- Built-in Editor
- Connection to any system editor
- Connection to the Data Dictionary DOMAIN
The translation units written in SQL-PL are called modules. These are of the following kinds:
- Routines
- Functions
- DB procedures
- DB functions
- Triggers
Every module is assigned to a program. The programs of a user form his or her private SQL library. For the programs in his library, a user can grant the call privilege to other users; these are allowed to call the programs but not to modify or delete them.
SQL-PL programs can only be called by users who are known to the database system. For users to be able to write their own programs, they must have the RESOURCE or DBA privilege, i.e. the right to create private tables in the database.