SQL query tool - Implementation
Prerequisites
Authorizations
This function is object-managed, meaning that:
-
Creation, modification, and deletion operations can be activated or deactivated per user.
-
You can apply role-based filters to restrict access.
-
An access code filter is performed using the ACS field. If an access code is provided, the inquiry and modification rights are granted based on the read/write permissions associated with the current user's function profile.
Tables used
The following tables are implemented by the function:
|
Table |
Table description |
|---|---|
|
ACLOB [ACB] |
Special folders |
|
ALISTED [ALD] |
Query tool |
|
ALISTEH [ALH] |
|
|
ALISTER [ALR] |
Query tool |
|
AREPORTV [ARV] |
|
|
ATEXTRA [AXX] |
Texts to translate |
|
ATYPE [ATY] |
This function updates the following table that is shared across all folders, located in the supervisor:
|
Table |
Table description |
|---|---|
|
ABLBSYS [ASB] |