Process DOSTAB: DOSTAB
MAJTAB
This entry point is integrated after the generation of the table in the database. It is used for example to generate the triggers, to initialize the new fields in the table etc.
This entry point is called from the DOSTAB process at the end of the MAJTAB sub program. This sub-program generates the .srf file in the FIL directory of the application from the table dictionary, then the system command 'valfil' generates the .adx file and validates the table in the database. This sub-program updates the structure of the table in the archived folder.
This sub-program is called from the validation of a folder, dictionary copy/validation, integration of a patch to a table and the management of the table dictionary (Validation button).
Context and operating mode
The following tables are on line :
|
Table |
Significant content |
Table description |
|---|---|---|
|
ADOSSIER [ADS] |
No |
|
|
ATABLE [ATB] |
No |
|
|
ATABZON [ATZ] |
No |
Field dictionary |
|
ATABIND [ATI] |
No |
Index dictionary |
|
AINDEX [ANX] |
No |
|
|
ATYPE [ATY] |
No |
|
|
ACTIV [ACV] |
No |
|
|
ATEXTE [ATX] |
No |
Dictionary messages |
The arguments transferred in this sub-program are TABLE (Table name) and FORCE. This flag is set to 1 if a forced validation is chosen for the table (valfil -f).
The other accessible variables are:
- The ADOSSIER table variables corresponding to the current folder (database type, data format etc.)
- The variables of the dictionary header table ATABLE
The following tables are open in the validated folder:
- ATABLE (table header)
- ATABIND (description of table index)
- ATABZON (description of table fields)
- ATEXTE (dictionary messages)
- ATYPE (data type)
- AINDEX (description of specific index)
- ACTIV (activity codes
NOLIMIT: Verification of a table before its generation in the database
This entry point is located under the sub-program used to reference the tables that are not to be verified. This sub-program is called within the table dictionary management and before the generation in the database.
These controls allow to verify that the number of fields in a table does not exceed 255, the size of the record does not exceed 32000 (oracle) or 8060 (SQL) and the number of columns (fields + size) does not exceed 512.
Context and operating method
The following tables are on line :
|
Table |
Significant content |
Table description |
|---|---|---|
|
ADOSSIER [ADS] |
No |
|
|
ATABLE [ATB] |
No |
|
|
ATABZON [ATZ] |
No |
Field dictionary |
|
ATABIND [ATI] |
No |
Index dictionary |
|
AINDEX [ANX] |
No |
|
|
ATYPE [ATY] |
No |
|
|
ACTIV [ACV] |
No |
|
|
ATEXTE [ATX] |
No |
Dictionary messages |
Variables used:
TABMAXZON and NBMAXZON are used to reference the tables for which the number of fields should not be verified
TABMAXLNG and NBMAXLNG are used to reference the tables for which the length of the record should not be verified
TABMAXCOL and NBMAXCOL are used to reference the tables for which the number of columns should not be verified
You can view the current information of a table from the Options/Information menu of the table dictionary.