KB200715 - XFOR: How to Save Mapping Rules for LDE Using SQL

MORE INFORMATION

There are times when you need to dump the current Mapping Rules of a Linkage LDE environment to send to Microsoft PSS. To do so:

Start the SQL query tool, ISQL/w. Verify that LSDXMMD is the selected database.
Using ISQL/w, under the query window type setuser DXAdmin and on the Query menu, click Execute. This sets the user to DXAdmin. If this does not complete successfully, the next step will not function properly.
Using ISQL/w, under the query window type SELECT * FROM MapFields, and on the Query menu, click Execute. In the Results window, it returns the current Mapping Rules for Linkage LDE. Save the results in an .rpt file called MapRules.rpt by clicking Save As on the File menu.