Alternate Collating Sequence - Database Property (Magic xpa 2.x)
Zoom from the Alternate Collating Sequence (ACS) setting to an Open File dialog box. Select the ACS file. The file name appears in the ACS Properties setting. Note that if no ACS file is specified in the ACS setting, Magic xpa will look for an ACS string in the Database Information setting. If no string is found, then Magic xpa will access the ACS file defined in the Alternate Collating Sequence File setting of the Environment dialog box.
The ACS file that appears in this setting reflects the ACS file set for the DBMS. When a new DBMS is selected for a specific database, the ACS file changes.
Once the connection to a database is created, it is only disconnected explicitly or by exiting Magic xpa (only exiting the application leaves the connection open). Therefore, the changes made in the database properties will take effect only in the next connection to the database. It is recommended to exit and re-launch Magic xpa whenever change database properties that affect Magic xpa gateway behavior.
SQL Considerations
