The customer is an international manufacturer of quality furniture. All materials management and bills of materials applications are own developments and tailored to the special requirements. The data is stored in hierarchical DL/I databases.
The aim is to implement materials management and parts list processing in the company network via web applications and to combine the information from the DL/I databases with the corresponding graphics from product planning.
The original plan to migrate from DL/I to a relational database was discarded for cost reasons. The decision in favor of tcACCESS was made on the basis of a reference visit to a tcACCESS customer.
tcACCESS represents the link between the mainframe and the web applications. The parts list information available in the DL/I databases can be retrieved from the web applications via SQL requests. The hierarchical DL/I data is thus treated like relational tables.
Information per application is stored in a MySQL database and specify which fields in the DL/I database should be accessed and whether SQL functions (e.g. SUBSTR, LEFT, etc.) should be used for certain columns, as well as color attributes of the values in the browser.
With the help of this information, the data is read and processed via tcACCESS. Changes in the DL/I databases (new or modified or deleted fields or segments) can thus be easily made in the SQL database without having to change the access programs.
The application is being used by the department and has been received very positively, especially the web interface and the associated options for easily linking components to one another.
The application has been received very positively by the department, especially the web interface and the associated options for easily linking components with one another.
The DL/I database became a relational database.