Since SQL/MP table naming conventions restrict names to eight characters and limits the character set that can be used, you can create a mapping file to map SQL/MP table names to logical names.
Create a mapping file called NAVMAP in the subvolume where AIS is installed. In the NAVMAP file you define a section for each SQL/MP data source (defined in the binding settings) for which you want a mapping. Within each section you specify the mapping you want for each table name in the database, as it is identified in Attunity Connect.
Enter the following syntax in the NAVMAP file for each table name:
table_alias = \machine_name.$volume_name.subvolume_name.filename
For example:
a1 = \mach1.$D3018.sqlmp.emp


LinkBack URL
About LinkBacks




Reply With Quote