Script ABIVALBAS: Datawarehouse validation
MAJTAB: Modification of the date synchronization
This entry point is used to take control every time a supervisor table is being validated. For example, it makes it possible to add an additional column.
Warning:
This table is used in the whole datawarehouse. For the database as well as the universe generation.
.
Context and operating method
The entry point MAJTAB is called before each validation of the supervisor table.
It is necessary to update a grid with variables which is used as a parameter of the program.
Description of the variables:
Subprog:
Subprog MAJTAB(TABLE,ABREV,INTIT,NBENR,STK,NBFLD,TBFLD,TBINT,TBTYP,TBLNG,TBACT,NBIDX,TBIND,TBACX,TBHOM,FORCE,SILENCE,OK)
Parameters:
Value Char TABLE: # Table name
Value Char ABREV: # Table abbreviation
Value Char INTIT: # Table title
Value Decimal NBENR: # Number of records
Value Clbfile STK
Value Integer NBFLD: # The number of fields in the table
Value Char TBFLD()(1..) : # Field name
Value Char TBINT()(1..) : # Field title
Value Char TBTYP()(1..) : # Field type
Value Decimal TBLNG(1..) : # Field length
Value Char TBACT()(1..) : # Activity code of the field
Value Integer NBIDX: # Number of indexes
Value Char TBIND()(1..) : # Index name
Value Char TBACX()(1..) : # Activity code of the index
Value Integer TBHOM(1..) : # Homonyms
Value Integer FORCE: # Force validation
Value Integer SILENCE
Variable Integer OK