Part of SWAT Framework's handle format is the table ID, namely, the first 3 digits portion, which has the function to specify which table contains the corresponding record.
To make use of the handle system, the application's tables need to be registered in the framework.
The pasoe config-xml contains a field 'TableDefinitionsDumpFile' in which the name of the XML-File is specified. This XML file contains a record for each table.
To create/update this File, the Akioma/Swat/Util/buildTableDefinitionFile.p procedure has been implemented to register the tables of a given database.
The procedure accepts 4 parameters:
| Parameter name | Type | Description |
|---|---|---|
| pcSourceFile | CHARACTER | A file containing the serialized representation of a dataset containing the currently registered tables. The dataset is the one defined in Akioma/Swat/System/dsTableDefinition.i. Can also point to a non-existing file, in which case it will be ignored. |
| pcTargetFile | CHARACTER | A valid location in the file system, where the result of the procedure will be exported to an XML file. The resulting file, similar to the source file, will be the XML serialization of the dsTableDefinition dataset. |
| pcDatabaseList | CHARACTER | A comma-separated list of databases which will be processed. If unknown or empty, it will be ignored and it will import the first database in the connection list. |
| piStartingId | CHARACTER | An integer signifying the hexadecimal representation of the first available ID. |
Sample call
RUN Akioma/Swat/Util/buildTableDefinitionFile.p("D:/Temp/source.xml", "D:/Temp/target.xml", ?, ?).