Entry points > Module Supervisor > Standard script 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 initialise the new fields in the table etc.

This entry point is called from the DOSTAB process at the end of the MAJTAB sub programme. This sub-programme generates the .srf file in the FIL directory of the application from the dictionary for the table then the system command 'valfil' generates the .adx file and validates the table in the database. This sub-programme updates the structure of the table in the archived folder.

This sub-programme 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

Folder table

ATABLE [ATB]

No

Table dictionary

ATABZON [ATZ]

No

Field dictionary

ATABIND [ATI]

No

Index dictionary

AINDEX [ANX]

No

Specific index

ATYPE [ATY]

No

Data types

ACTIV [ACV]

No

Activity codes

ATEXTE [ATX]

No

Dictionary messages

The arguments transferred in this sub-programme 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 namely:
- The variables of the ADOSSIER table corresponding to the current folder (database type, data format, etc.)
- The variables of the ATABLE dictionary header table

The following open tables are open in the validated folder:
- ATABLE (table header)
- ATABIND (description of the indexes in the table)
- ATABZON (description of the fields in the table)
- ATEXTE (dictionary texts)
- ATYPE (data type)
- AINDEX (description of the additional indexes for the table)
- ACTIV (activity codes)