$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;