SQL query tool - Implementation
Prerequisite
Authorizations
This function is object managed. The creation, modification, anddeletion operations can be activated or deactivated for a given user.Filters by rolescan also be associated with this function.
A filter by access code is performed, based on the field named ACS. If an acess code is given, the inquiry and modification rights are granted according tothe reading and writing rights associated with the code of the current user in their 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 tables shared by all the folders, located in the supervisor. These tables are the following :
Table | Table description |
|---|---|
ABLBSYS [ASB] |