IndexMapping4 : Index mapping in MS Access
This example shows how to map index names if the names in the
database are different from the ones in the GAMS model.
In this case all mapping is handled inside the database.
Files: Sample.mdb IndexMapping4.gms
<![CDATA[
$ontext
This example shows how to map index names if the names in the
database are different from the ones in the GAMS model.
In this case all mapping is handled inside the database.
$offtext
set i /NY,DC,LA,SF/;
$onecho > cmd.txt
C=DRIVER={Microsoft Access Driver (*.mdb)};dbq=Sample.mdb
q=SELECT [GAMS City], [value] FROM [example table],CityMapper WHERE [Access City]=city
o=city2.inc
$offecho
$call =sql2gms @cmd.txt
parameter data(i)/
$include city2.inc
/;
display data;
]]></plaintext></body></div>