French Access Switch DML involves configuring Data Manipulation Language (DML) access rules and interface settings, often with French-language screen labels or localized environments.

DML in French-Language Software Environments

When using systems like Sage 300 with French-language screens, DML configurations must account for localized field labels. For example, in Accounts Payable (A/P) Invoice Entry, the French desktop screen labels are N° FOURNISSEUR for Vendor Number and N° DOCUMENT for Document Number, while web screens use NUMÉRO FOURNISSEUR and NUMÉRO DOCUMENT. Each language requires separate configuration rows in the Document Management Link (DML) setup to ensure proper access and functionality for French users .

Implementing Access Restrictions in DML

DML can manage access to registers or fields across multiple interfaces. A common approach is to maintain a central register bank with unrestricted access and then apply interface-specific restrictions. For instance, one interface may have read/write access, while privileged interfaces lift restrictions selectively. Access logic can be implemented either in the main DML bank or in the interface-specific banks, forwarding allowed operations to the main bank. This design allows clean separation of access rules and simplifies maintenance .

DML in CA IDMS

In CA IDMS, DML is embedded within host languages like COBOL or PL/I and requires pre-compilation. Databases can be accessed in local mode (single-user, batch applications) or central version mode (multi-user, concurrent access). Proper DML configuration ensures that French-language users or localized applications can interact with the database while respecting access rules and concurrency controls .

Key Considerations

• Localization: Ensure all French-language field labels are correctly mapped in DML configurations.
• Interface-Specific Access: Define access rules per interface to control read/write permissions.
• Centralized vs. Interface Logic: Decide whether to enforce restrictions in the main DML bank or in interface-specific layers.
• Pre-compilation: For CA IDMS, DML statements must be pre-processed to generate host-language calls. By carefully configuring DML with these considerations, French-language users can securely and efficiently access the required data while maintaining proper access control.